Hi,<BR><BR>I have a database with huge data(million's of records).When i am creating my recordset with a query , it is giving out of memory error.<BR>Does any body know how to proceed ?<BR><BR>Neelima
> Only query data you need, data you are actually going to display on the screen at once.<BR><BR>> Explicitly define the fields you need not SELECT *, use SELECT UserName, etc...<BR><BR>> Perhaps use stored procedures/views etc.. if you are using SQL Server<BR><BR>> Install memory in the server.<BR><BR>
right now i am doing the first three points u have mentioned.<BR>i did not understand what do u mean by install memory in the server<BR>Right now we r using iis5.0 on win2000 server.Do we need to configure the server for performence?
You may need to stuff some more physical memory into the thing. At current prices, that shouldn't be TOO painful. You could also try increasing the size of your swap file and see if that helps. I run my swap file on its own partition to avoid fragmentation.
Sorry I have NT4 not win2000, but I'll tell you how you do it in NT and maybe it is applicable to Win2K or least point you in the right direction:<BR><BR>>Right click on My Computer<BR>>Select performance Tab<BR>>Under the virtual memory section click [Change] increase the Initial size to as much as you can spare i.e. 1024 and the same or more for the maximum size.<BR><BR>You still might need to buy more physical memory for your server for performance.