Hello

I've been looking into this and it looks like my initial table design is good, and my indexing is good. The problem is basically that my database is huge, and the searches are huge.

I've always tried to limit the amount of unrelated results, so when you search for "customer care" I don't want "career" to be matched, but I do want "care,", " care ", ",care", "care." etc. So the searches are pretty complex.

And I can't index the body of the jobs (which is where the majority of the searches are aimed at.)

So I guess upgrading my server is one of my only options.

Ah well, it's about time I bought a server and colocated anyway, so I'll start looking into that.

Thanks everyone for your help.

PS Dan, I'm going to look into that Sphinx Search. Might be a possibility.

What sizes are the tables and how complex are the queries? Have you chosen good indices?

Again, a tweaked installation on a Celeron can outperform some higher spec machines that have not been optimised.

The basic rule of thumb with databases is that RAM is often the bottleneck. If the temporary table in Mysql (if you are using myisam) grows too big for RAM, it will swap to harddisk. Run some of your queries and look at the processlist (show full processlist; ) and see if it swaps the tmp table to harddisk. Also time it if possible. That way you should get an idea of things.

Hard to give a definite answer without knowing the question.

Regards...jmcc

You might want to look at this http://www.day32.com/MySQL/tuning-primer.sh script and see if it can recommend anything for you to tune up.

However having done the whole run a web hosting company from one crappy celeron server, it sounds like it might be upgrade time. However I'd stay away from colo unless you have a really good idea of what you are doing and have no problem with a 3am trip into a dc.

DRAM is cheap, why not go for something closer to 2GB ?

__________________
my sites :

irish poker / irish jobs / seo faq / advertise jobs free / green card / skiing / geansai gorm

I've upgraded my secondary machine to 4 gigs of RAM and this one is getting the same (once the bios decided to play nice!)

__________________
Hosting & Domains|Plesk Vps Hosting|Geek / Cool Stuff|Films.ie|Cool Sites|Monetisation Tips|Movie Chat


Energise your forum! Click here for info