poor performance on first query

Tech-Archive recommends: Fix windows errors by optimizing your registry

satchinchico_at_yahoo.com
Date: 01/21/05 

Date: 20 Jan 2005 21:12:38 -0800

I've got an ASP site querying an Access database to get photo gallery
thumbnails. There are two types of queries, all on a single table with
15,000 records. For both types, performance for the first query is
poor, and improves on the 2nd and so on. The worst case is the free
search query against two fields, including a memo field - something
like this: SELECT field1, field 2, field 3 FROM myTable WHERE keywords
LIKE keyword OR memofield LIKE keyword ORDER BY field3 DESC

For the two-field query, we're talking a 30-second delay on the first
query, improving on the second try to 5 or 6 seconds. In this way, it
seems to relate to server sessions. That is, a visitor's first search
takes forever, but once that's over with (if they haven't left in
disgust) the speed is acceptable.

Any ideas? Thanks in advance.

Karl

Relevant Pages

  • RE: Search Form - Take 2
    ... The search function is working like a charm when I enter a keyword in the ... as its due to the fact that the columns in master allow Nulls. ... Recommendations and Accomplishments tables an extra ... Create a query in which the Master table is joined to each of the other ...
    (microsoft.public.access.gettingstarted)
  • Re: Help needed on creating a subform
    ... Don't enter anything in this procedure yet but scroll down below the End Sub ... "ORDER BY QuoteId DESC, Keyword" ... based on the current value of the quote id. ... A UNION query concatenates the results of two separate queries. ...
    (microsoft.public.access.forms)
  • Re: Creatinig a database to update in alphabetical order
    ... You can then create a Query which takes all of the records in the ... Some attributes of a movie would be the Title, the studio, ... MovieID Autonumber Primary Key ' links tables together ... Keyword ...
    (microsoft.public.access.gettingstarted)
  • Re: SELECT DISTINCT records based only on two columns
    ... a bit more light on how the DISTINCT keyword works. ... I see my mistake was to include the UID field in my query. ... 3,345678901,John2,Doe,456 Dough St,,Columbus,OH,43215 ...
    (microsoft.public.sqlserver.mseq)
  • RE: Joining tables based on strings contained within field
    ... Open up a new query based on the Main table. ... paste in the SQL statement below after removing what already there. ... Jerry Whittle, Microsoft Access MVP ... the Keyword table showing only the Key column? ...
    (microsoft.public.access.queries)