Re: Slow searches in large database
| From: | Mohamed Lrhazi | Date: | Wed, 15 Oct 2003 02:16:10 +0000 |
| Subject: | Re: Slow searches in large database | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-166152@lists.php.net to get a copy of this message | ||
You might wanna see if a search engine/indexing tool can help you, I
use:
http://search.mnogo.ru/features.html
On Mon, 2003-10-13 at 18:54, Adrian Teasdale wrote:
> Hi there
>
> Wondering if someone could help or give some advice.
>
> We have a mysql database that has approximately 20,000 records and has a
> total size of 125mb There are approximately 25 fields that we need to
> search each time that someone performs a search. We have installed
> TurckMMCache onto the server which speeded up the searching, but it
> still takes around 15 seconds for the results to be displayed.