Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 3 of 3
  1. #1
    Regular Coder
    Join Date
    Jan 2005
    Posts
    470
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Results undesirably randomized in fulltext search

    I am running a simple query that performs a fulltext search and sorts by score. Everything has been running fine for months now when suddenly I am seeing random results returned in some cases, in others I see less results returned than should be, and in others I see results that are the same but randomly sorted.

    I tried copying the database over to another server and ran the exact same fulltext query there. The results that come back are consistantly what is to be expected on this other server.

    What could cause such differing results with the same database and query on two separate machines with the same setup?

  • #2
    Regular Coder
    Join Date
    Jun 2005
    Posts
    804
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Different collations could cause different sorts. Are you getting these differences in direct queries or via a script? Can you post the query?

  • #3
    Regular Coder
    Join Date
    Jan 2005
    Posts
    470
    Thanks
    3
    Thanked 0 Times in 0 Posts
    Turns out the options file wasn't transferred during a recent server move. It simply lacked the correct settings to agree with the index that had already been built.

    Works fine now.


  •  

    Posting Permissions

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