View Poll Results: Which Price Comparison site do you use?

2. You may not vote on this poll
Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2004

    Question Unanswered: Suggestion for a faster search on keyword?

    Hi everyone...

    I am a programmer for

    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?


  2. #2
    Join Date
    Mar 2004


    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.

  3. #3
    Join Date
    Apr 2003

    Smile Schema

    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
    Open up
    Take a look to my Blog

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts