Link to home
Start Free TrialLog in
Avatar of lapucca
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.
Avatar of Pawan Kumar
Pawan Kumar
Flag of India image

Why you want to store heavy tables in the UI. Try to do all the operations at the database level itself.

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!
Avatar of lapucca
lapucca

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.
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 !
ASKER CERTIFIED SOLUTION
Avatar of Member_2_4913559
Member_2_4913559
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of lapucca

ASKER

Thank you!  Your answer is exactly what I'm looking for, paging or read adapter would be best!