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?