Gossamer Forum
Home : Products : Gossamer Links : Discussions :

sql version searches are slower than static db

Quote Reply
sql version searches are slower than static db
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.
Quote Reply
Re: [socrates] sql version searches are slower than static db In reply to
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
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!
Quote Reply
Re: [socrates] sql version searches are slower than static db In reply to
Have you indexed?