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

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

    Question Unanswered: Suggestion for a faster search on keyword?

    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

  2. #2
    Join Date
    Mar 2004
    Posts
    110

    server?

    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
    Location
    Tunisia
    Posts
    192

    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 http://www.rundom.com/karim2k

Posting Permissions

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