'Out Of Memory Exception' during Data Access
-
Hi, I am querying a DB and I want to get the data (Around 1 crore records) in a dataset. then I want to perform other operations on the data in the dataset. However, the process does not complete correctly. The program displays an 'Out Of Memory Exception' and the process is terminated. Can anyone suggest how this issue can be overcome. Thnx for any help. With Best Regards, Mayur
-
Hi, I am querying a DB and I want to get the data (Around 1 crore records) in a dataset. then I want to perform other operations on the data in the dataset. However, the process does not complete correctly. The program displays an 'Out Of Memory Exception' and the process is terminated. Can anyone suggest how this issue can be overcome. Thnx for any help. With Best Regards, Mayur
Mayur, A closest discussion thread for your problem in hand: http://forums.oracle.com/forums/message.jspa?messageID=904915[^] Vasudevan Deepak Kumar Personal Web: http://www.lavanyadeepak.tk/ I Blog At: http://www.dotnetjunkies.com/weblog/deepak/
http://deepakvasudevan.blogspot.com/
http://deepak.blogdrive.com/ -
Mayur, A closest discussion thread for your problem in hand: http://forums.oracle.com/forums/message.jspa?messageID=904915[^] Vasudevan Deepak Kumar Personal Web: http://www.lavanyadeepak.tk/ I Blog At: http://www.dotnetjunkies.com/weblog/deepak/
http://deepakvasudevan.blogspot.com/
http://deepak.blogdrive.com/Thnx Deepak. I am using Vb.NEGT with MS Access. Do you mean to say that I need to use OledbDataReader to retrieve the data? With Best Regards, Mayur
-
Hi, I am querying a DB and I want to get the data (Around 1 crore records) in a dataset. then I want to perform other operations on the data in the dataset. However, the process does not complete correctly. The program displays an 'Out Of Memory Exception' and the process is terminated. Can anyone suggest how this issue can be overcome. Thnx for any help. With Best Regards, Mayur
How many records are you reading??? Are you sure to need them all in memory at the same time, or can you get away with only reading a few at a time, while doing your processing. And, yes, with an Access database, you have to use the OleDb database classes. RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
-
How many records are you reading??? Are you sure to need them all in memory at the same time, or can you get away with only reading a few at a time, while doing your processing. And, yes, with an Access database, you have to use the OleDb database classes. RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
Hi, I am trying to get the entire data into the dataset and then let the user query this dataset as per his needs. What is happening currently is that every query is being run directly on the database. I want to avoid this. With Best Regards, Mayur
-
Hi, I am trying to get the entire data into the dataset and then let the user query this dataset as per his needs. What is happening currently is that every query is being run directly on the database. I want to avoid this. With Best Regards, Mayur
I take it that you're loading 1 Million records? You're MUCH better off leaving the data in the database and just running the queries against that. The .NET Framework objects are not designed to handle that much data and are not nearly as efficient at searching through it as the database engine is. The traffic you send and, more importantly, receive to/from the SQL Server (or whatever) will be FAR less than retrieving that mountain of records. RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome