Agreed, putting a database index on the delta column is definitely a good idea.
-- Pat On 25/01/2011, at 4:03 PM, Aaron Gibralter wrote: > Ok so I'm just revisiting this now as I've noticed a bit of a performance > issue with delta indexes on large tables. I noticed that before delta > indexing, sphinx runs what's specified as "sql_query_range" in the conf. > > It looks something like this: > > sql_query_range = SELECT IFNULL(MIN(`id`), 1), IFNULL(MAX(`id`), 1) FROM > `users` WHERE `users`.`delta` = 1 > > ... and for the normal core: > > sql_query_range = SELECT IFNULL(MIN(`id`), 1), IFNULL(MAX(`id`), 1) FROM > `users` WHERE `users`.`delta` = 0 > > Clearly these queries can benefit from indexes on the delta column. > > -- > You received this message because you are subscribed to the Google Groups > "Thinking Sphinx" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/thinking-sphinx?hl=en. -- You received this message because you are subscribed to the Google Groups "Thinking Sphinx" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/thinking-sphinx?hl=en.
