Author: Alexander Email: Barkov Message: Probably your database is big enough. This is why first query is slow. Databases usually always give second response for the same query faster. This is because system read/write buffers are already cached in memory, the same is with database internal buffers. This is very noticeably with MySQL, it uses threads and indexes are cached in shared buffers. With database which use separate process for each client you may not notice effect so much perceptible.
> For some reason, when performing a search on my indexed database, the first search >always takes a long time (5-10 secs). Any further searches after that are very >quick. Why is the very first search always slow. > > This has nothing to do with the caching function as even if the second search is a >unique keyword (ie never before used) it is still very quick. > > anyone know the answer Reply: <http://www.mnogosearch.org/board/message.php?id=3223> ___________________________________________ If you want to unsubscribe send "unsubscribe general" to [EMAIL PROTECTED]
