Hi,
Make sure the words.word field is indexed and that the pages.id is an
indexed primary key.
Cheers,
Andrew
-Original Message-
From: Jasper Bryant-Greene [mailto:[EMAIL PROTECTED]
Sent: Friday 30 January 2004 21:39
To: [EMAIL PROTECTED]
Subject: MySQL optimisations for search
Jasper Bryant-Greene wrote:
Hi
I'm running a small search engine that indexes the web, but have been having
trouble with optimising it to handle the load.
There are two tables involved in searching - `pages`, which stores the ID,
URL, title and crawl date, and `words` which has two rows - `word
Hi
I'm running a small search engine that indexes the web, but have been having
trouble with optimising it to handle the load.
There are two tables involved in searching - `pages`, which stores the ID,
URL, title and crawl date, and `words` which has two rows - `word` and
`page` where `word` i