Speed up search queries changes numer of items in database?

Comments

3 comments

  • Avatar
    Chris Muench

    The 30,000 is expected as it doesn't count how many results there are (which speeds up searching). If it starts with BS- and you are NOT using enhanced search method (store config), that should work.

    0
    Comment actions Permalink
  • Avatar
    Marc

    Thank You! Turning off Enhanced search did return the functionality for the search we needed.  Enabling the speed up search queries does indeed speed up queries but I notice if it's enabled the "column sort" functions at the top of the item lists in admin no longer function?  Is that normal? I am running 17.0 build from 7/23

    0
    Comment actions Permalink
  • Avatar
    Chris Muench

    It is normal that speed up disables that feature. It is for performance

    0
    Comment actions Permalink

Please sign in to leave a comment.