Hi,
We have a very large database of just under 4 million links. Our directory is running great, but searches are taking a long time.
Single keyword searches are just about bearable, but multiple keyword searches are taking a very long time unless those particular searches have already been made as we cache the results.
What is the best way to optimize LinksSQL and how could we squeeze every last drop of performance gain we can out of the search?
And ideas and suggestions are very welcome.
Thanks in advance,
Kev
-------
BN23.com - LinksSQL powered search and directory.
5.2 Million Links, 685,000 Categories
We have a very large database of just under 4 million links. Our directory is running great, but searches are taking a long time.
Single keyword searches are just about bearable, but multiple keyword searches are taking a very long time unless those particular searches have already been made as we cache the results.
What is the best way to optimize LinksSQL and how could we squeeze every last drop of performance gain we can out of the search?
And ideas and suggestions are very welcome.
Thanks in advance,
Kev
-------
BN23.com - LinksSQL powered search and directory.
5.2 Million Links, 685,000 Categories