Records Retrieving problem

Results 1 to 2 of 2

Thread: Records Retrieving problem

  1. #1
    Ronald Guest

    Default Records Retrieving problem

    hi, got a doubt on performance. here is the lines of code.<BR><BR>dim cnn,rs<BR><BR>set cnn=adodb.connection<BR>set rs=adodb.recordset<BR><BR>rs.caschesize=100 //i want to retrieve records t<BR> interval of 100 from dbase.<BR> somesql,cnn,adopenstatic,lockreadonly<BR><BR>probl em is when i retrieve around 1000 records its fine. but when i retrieve around half a million records or say considerably more than 1000 then server load is to peak and my application is crashing.<BR><BR>is there anything to do with cachesize for this or any specific reason? i would be happy if anyone can point out where i am going wrong.<BR><BR>i feel that retrieveing records in chunks of 100 per time would work in maintaining the server load.<BR><BR>thanks in advance<BR><BR>Ronald

  2. #2
    Join Date
    Dec 1969

    Default RE: Records Retrieving problem

    1000 records is a bit much, isn&#039t it?<BR><BR>try paging your results. there are tutorials everywhere on the web for this<BR><BR>j<BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts