Thread: More powerful server... how much faster will my SQL queries be?
View Single Post

  #1 (permalink)  
Old 27-06-2007, 12:46 AM
dude dude is offline
Wannabe Geek
  
Join Date: Sep 2006
Posts: 193
Nominated 0 Times in 0 Posts
TOTW/F/M Award(s): 0
dude will become famous soon enough
Default More powerful server... how much faster will my SQL queries be?
Hello

I run a couple of websites which do complex "like '%word%'" SQL queries (such as this: Jobseeker - Jobs )

Some of my queries are a bit slow.

My server is a fairly basic celeron (can't remember the exact spec, but I think it's 1.8 Ghz with 512 MB ram.)

If I were to upgrade to say... a Xeon 2.8 Ghz with 1 Gig ram, would my SQL queries run much faster?

Or is there a smarter way to speed up my queries?

Any advice appreciated. Thanks!
Reply With Quote