locked
Datatable/Dataset total memory RRS feed

  • Question

  • User-2122596307 posted

    Hi everyone,

    I make a query which will give me 200,000 results and bind it to the datatable but the error will pop out saying out of memory or request timed out.

    Can datatable/dataset handle these records or is my current server's hardware needs a little upgrade?

    Actually we are gettings millions of data and i dont have any idea how to solve this one? Have you worked on this kind of data? Do you have any idea on how to send my command from server A to server B while server A also processing request and will not wait for server B's result and server B will just update the records in my database, i think this can solve my problem if doing it  in parallel.

    Any idea please?

    Tuesday, March 15, 2011 9:16 PM

All replies

  • User1983487377 posted

    hi...

    please do a very small change where you are fetching Data from Command to DataAdapter..

    cmd.CommandTimeout = 0;

     

    If not getting expected result then please post the code of Binding Data...

     

    All the best

    Wednesday, March 16, 2011 12:58 AM