I have the entire DMOZ mirror running on my site (http://dir.canseek.ca) using Links SQL. The system handles it fine except searches for phrases longer than one word take upwards of 20 seconds... I need to find a way to speed this system up. Currently the web server handling the directory is dedicated to specifically the directory itself. Other sections of the site are on different boxes. Also, the SQL portion is on a seperate dedicated box as well (P4-3.06, Linux, 2 Gig RAM, fast IDE etc.)..

I am using MySQL as my indexing method... should I convert to internal or am I missing something?

Thanks in advance,

Paul Stewart

Try using INTERNAL INDEXING. Its quite a lot quicker for the user, but does take a while to build up the keyword list :(

Cheers

Andy (mod)
andy@ultranerds.co.uk

---

Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!

I'm sure I remember Alex saying something about the mysql indexing being better now than internal for large databases - as long as you have a certain version of mysql - but I can't find the thread now.