Re: Slow searches in large database
| From: | Cesar Cordovez | Date: | Thu, 16 Oct 2003 13:36:57 +0000 |
| Subject: | Re: Slow searches in large database | ||
| References: | 1 2 3 4 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-166325@lists.php.net to get a copy of this message | ||
Manu, et al,
The database in alenet.com is rather tiny (about 28 docs, as you mentioned). I developed the procedure for a intranet with some 5000 records. It is working fine. It has some 20+ clients that are constantly hitting the database. The server is a desktop (nothing out of the ordinary, running win32)
Manuel Vázquez Acosta wrote:
I used a variant of this scheme a time ago and it worked well though I had not reached 2 000 records. I separated the words using strtok(). Manu. PD: How large is the http://www.alenet.com DB; I searched the word 'the' (which is likely to be in every english doc) and it returned only 28 docs. Manu.