Faster Database Access

Results 1 to 2 of 2

Thread: Faster Database Access

  1. #1
    Join Date
    Dec 1969

    Default Faster Database Access

    Hi,<BR><BR>I have SQL database with over 200,000 records in it; and it&#039s real slow when somebody tries to view all of it at once (200 records per page). How could I improve my query? My query is below. Thanks in advance!<BR><BR>oRs.Open "SELECT * FROM useddomains WHERE 1=1 AND name like &#039%business%&#039 AND len(name) &#060; 30 AND dateAdded = &#039 8/26/00&#039 AND domainType = 1 ORDER BY dateAdded DESC, name", objConn, 3, 3

  2. #2
    Join Date
    Dec 1969

    Default RE: Faster Database Access

    You could use record paging to linit the number of records per page

Posting Permissions

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