lapucca
asked on
What's the most efficient way to load up a couple of large table in C#?
Hi, I'm using VS2013.
If I need to load up a couple of large tables and need to have them available for about 20minues. What's the best way to do this? ADO dataset loads in RAM which I want to make sure it doesn't slow down the server.
Thank you.
If I need to load up a couple of large tables and need to have them available for about 20minues. What's the best way to do this? ADO dataset loads in RAM which I want to make sure it doesn't slow down the server.
Thank you.
ASKER
Please clarify. Don't store the heavy tables in dataset and instead create short term heavy tables on database? These tables stores the results of some joint queries. The application needs it around for about 15 minutes only.
But you also said Dataset is good. That is my question. Should I use dataset to store these short term table or create them in sql server database and then drop them 10-20 minutes later?
Which is a better practice? Thank you.
But you also said Dataset is good. That is my question. Should I use dataset to store these short term table or create them in sql server database and then drop them 10-20 minutes later?
Which is a better practice? Thank you.
Well the whole idea is perform all the database related operations at database level itself and the final output should be returned to the UI.
If you still need data in UI then DataSet is good for storing data. So if possible do this at DB level , if not possible then only use UI.(DataSet)
Hope it helps !
If you still need data in UI then DataSet is good for storing data. So if possible do this at DB level , if not possible then only use UI.(DataSet)
Hope it helps !
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you! Your answer is exactly what I'm looking for, paging or read adapter would be best!
Try using DataSet via DataAdapter using disconnected Architecture.
DataSet is a very good choice for storing data from Database.
For caching data you can use objects like Cache,ViewState or Session based on your choice.
Hope it helps!