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!
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!