I have about 2,000 links with a text database (old links - not sql) and they are large with several additional fields. I would say with normal structure they are about 4,000 or more links.

I am moving them to sql version and so far to test out, I have only moved about 500 links and I am surprised that with links sql, the searches and dynamic pages are slower than the text database version. The searches take much longer than the static db.

Really? Sounds odd to me :/

Also - don't forget, static files require "flocking" (to stop them getting corrupt by too many people reading them at once). MySQL doesn't have this problem - so you can have hundreds of people accessing the same data at once, and that wouldn't be a problem.

Cheers

Andy (mod)
andy@ultranerds.co.uk

---

IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Compare our different Plugin packages *new* Free CSS Templates

Have you indexed?