|
In my first post I mentioned Sphinx. It works well if you have the hardware to throw at it. Your queries shouldn't be that slow even on a shared server. The host's mysql server is probably overloaded. See how it performs on a decent VPS. You'll almost definitely need to tweak your my.cnf but a db of that size shouldn't be beating you up too badly.
I don't know how tgpx works either. I don't know its db structure or anything so it might be a script issue too. For the kind of searching you're trying to do a fulltext index should exist on whatever column holds the descriptions and then use a fulltext query. If your search script is doing something like "SELECT * FROM tablename WHERE description LIKE %SEARCHTERM%" then that's a massive problem.
|