Performance Question

Results 1 to 2 of 2

Thread: Performance Question

  1. #1
    Paul M Guest

    Default Performance Question

    Morning Forum,<BR>I am looking for advice as much as an answer to my question on this one.<BR>The situation I have is that I have multiple asp pages accessing a Access Db. At the moment all the tables have at most 8000-9000 records in them, and every SQL statement that is passed to the database contains muliple Where clauses that limit the return to at most 100 records. This is all displayed using LOOP , movenext, which doesn&#039;t seem to be a problem, but... we are going to have to alter the way the database is structured so that tables contain up 500k rows, and the number of records returned will be greater (~1000 or so).<BR><BR>Would I be advised to alter the way I return the records to getrows, taking in to account that I have a very tight timescale already ?

  2. #2
    Join Date
    Dec 1969

    Default RE: Performance Question

    1. upgrade to SQL server.<BR>2. er... that&#039;s about it...<BR><BR>j

Posting Permissions

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