Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Does large # of Links columns slow search?

Quote Reply
Does large # of Links columns slow search?
Hello,

I've been wondering if the slowing down of my search results could be do to the large number of "Links" Table columns I'm using? Are all Right now I have about 90 columns and would like to add more for additional image uploads. I'm just concerned additional columns will further slow my searches. Right now with only 150+ listings searches are sometimes returning at well over 1 second. I'm about to go live and I need to keep search times down if I expect to push 10,000+ listings in the near future. I'll have a much stronger box by then, but have to get off the ground first.

Thanks for any info or suggestions.
Quote Reply
Re: [Jonze] Does large # of Links columns slow search? In reply to
Have oyu tried INDEXed searches? That should speed things up a little...

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: [Andy] Does large # of Links columns slow search? In reply to
If your meaning "INTERNAL", yes that's the indexing scheme I have the Links table set to.