Re: poor performance on first query
From: Chris Hohmann (nospam_at_thankyou.com)
Date: 01/21/05
- Previous message: satchinchico_at_yahoo.com: "Re: poor performance on first query"
- In reply to: satchinchico_at_yahoo.com: "poor performance on first query"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 21 Jan 2005 10:50:45 -0800
<satchinchico@yahoo.com> wrote in message
news:1106284358.954566.220470@c13g2000cwb.googlegroups.com...
> 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
>
Are the thumbnails embedded in the database or does the database simple have
a path reference to the thumbnail file? If it's embedded you may want to
consider using path references instead. Here's an article explaining why:
http://aspfaq.com/show.asp?id=2149
- Previous message: satchinchico_at_yahoo.com: "Re: poor performance on first query"
- In reply to: satchinchico_at_yahoo.com: "poor performance on first query"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
