Suggestion for a faster search on keyword?

PriceComparison · #1 (**permalink**) 10-26-04, 12:37

Hi everyone...

I am a programmer for www.PriceComparison.com

We have a problem with slow searches..
We have made a specialized table for searching.
Indexing all the right fields are setup already.

I am thinking I may need to implement tsearch2 or full text indexing
technology. But that is a real push-up.

Any other option? Any suggestion?

Thanks

Andrew_@_PriceComparison.com
http://www.PriceComparison.com

Edje · #2 (**permalink**) 10-26-04, 13:25

Im kinda wondering what your db server(s) specs are. Using linux, windows? Replication perhaps?

Might be that your server(s) cant handle the load and/or you might try some other tweaking.

karim2k · #3 (**permalink**) 10-30-04, 10:04

We are running a giant databse build under a two 64bits Itanuim II - that have sloved such problmes as ou data us fully text ! You could have that push through :

- Indexing the items without the need for further tables.
- Using FTS (full text search) it really improves perfomances.
- take a look at your schema.
- Using more and more Functions, triggers and rules.

Good luck

Internet Services

Web Development

Digital Marketing

Consumer Tech