Datagrid Development Discussion
-
Topic : I have a datagrid (ASP.NET) and i need to bind this datagrid to a Database table. the number of records to be bound are, say... 100,000 or more... Agenda : How to achive this, while keeping the datafetching process very fast and the paging with out POSTBACK... Idea: using some XSLT , XML, or something? Adressing Issue : the issue of getting 100,000 or more data can be achieved by keeping a composite key and retriving only 10 records from database at a time to show in the datagrid and when the user clicks next or previous we can use that composite key to fetch the next batch of data. Makin it seem that all the data is in the datagrid but actually its still in the DB. That is not a very big deal Next Issue : the issue of paging without postback, that mean the data should all be out of the DB? or using the XSLT to pipe the data to the cliet and updata the datagrid? Anybody would like to comment on this? thanks and appreciate your time. "Rejoice always, pray without ceasing, in everything give thanks; for this is the will of God in Christ Jesus for you."1Thess. 5:16-18
-
Topic : I have a datagrid (ASP.NET) and i need to bind this datagrid to a Database table. the number of records to be bound are, say... 100,000 or more... Agenda : How to achive this, while keeping the datafetching process very fast and the paging with out POSTBACK... Idea: using some XSLT , XML, or something? Adressing Issue : the issue of getting 100,000 or more data can be achieved by keeping a composite key and retriving only 10 records from database at a time to show in the datagrid and when the user clicks next or previous we can use that composite key to fetch the next batch of data. Makin it seem that all the data is in the datagrid but actually its still in the DB. That is not a very big deal Next Issue : the issue of paging without postback, that mean the data should all be out of the DB? or using the XSLT to pipe the data to the cliet and updata the datagrid? Anybody would like to comment on this? thanks and appreciate your time. "Rejoice always, pray without ceasing, in everything give thanks; for this is the will of God in Christ Jesus for you."1Thess. 5:16-18
** Method to acoid data retricing in postback - Retrive the data in the page load - store it in the cache memory or session memory (see notes below) - Pick from the stored data when you do the post back Notes: If you feel all the data for all the users are same... store in the single Cache variable... else use separate ones. I would recomment cache var than the session, as session var may not supported in all IE settings. There is nothing new under the sun,
But there are lots of old things we don't know.
- Ambrose Bierce -
** Method to acoid data retricing in postback - Retrive the data in the page load - store it in the cache memory or session memory (see notes below) - Pick from the stored data when you do the post back Notes: If you feel all the data for all the users are same... store in the single Cache variable... else use separate ones. I would recomment cache var than the session, as session var may not supported in all IE settings. There is nothing new under the sun,
But there are lots of old things we don't know.
- Ambrose BierceThanks for ur thoughts... but the thing is bringning 100,000 records to the client side is not a good idea, let alone storing it in cache... Moreover, i am trying to avoid post back... maybe trying to use some XML and XSLT? or something to pipe the data from DB to the client, without storing data in client.... "Rejoice always, pray without ceasing, in everything give thanks; for this is the will of God in Christ Jesus for you."1Thess. 5:16-18
-
Thanks for ur thoughts... but the thing is bringning 100,000 records to the client side is not a good idea, let alone storing it in cache... Moreover, i am trying to avoid post back... maybe trying to use some XML and XSLT? or something to pipe the data from DB to the client, without storing data in client.... "Rejoice always, pray without ceasing, in everything give thanks; for this is the will of God in Christ Jesus for you."1Thess. 5:16-18
I dont know the proccess involved in your case. So, I am not sure if you can put the whole stuff in the single cache or individual cache depending on the content/users.... Regarding the postback issue... when we say that the contents are in the cache... it doesnt make much of a difference in the performance for the postback and paging. Anyway, I am not very sure of using the XML etc. There is nothing new under the sun,
But there are lots of old things we don't know.
- Ambrose Bierce -
I dont know the proccess involved in your case. So, I am not sure if you can put the whole stuff in the single cache or individual cache depending on the content/users.... Regarding the postback issue... when we say that the contents are in the cache... it doesnt make much of a difference in the performance for the postback and paging. Anyway, I am not very sure of using the XML etc. There is nothing new under the sun,
But there are lots of old things we don't know.
- Ambrose Bierceits ok if u are not sure about xml... but the whole point is to NOT keep any records in the cache...:D "Rejoice always, pray without ceasing, in everything give thanks; for this is the will of God in Christ Jesus for you."1Thess. 5:16-18