Hmm it seems like the sphinx.confs TS is generating always uses "WHERE `table`.`id` >= $start AND `table`.`id` <= $end AND `table`.`updated_at` > DATE_SUB(NOW(), INTERVAL ... SECOND)" meaning it's just using the primary key index and therefore only a 2-part index on [id, updated_at] would be useful. However, seems like this 2- part index would be serious overkill... guess no additional indexes are really necessary for sphinx after all.
On Apr 22, 10:29 pm, Pat Allan <[email protected]> wrote: > Hi Aaron > > I'd definitely put an index on the column if you're sorting or filtering by > it (and the SQL statements generated by TS will be doing the latter). Though > granted, I'm not a MySQL expert. > > Cheers > > -- > Pat > > On 23/04/2010, at 2:21 AM, agibralter wrote: > > > Does it make sense to create mysql indexes for the `updated_at` column > > if using ts-datetime-delta or the `delta` column if using ts-delayed- > > delta? > > > Thanks, > > Aaron > > > -- > > 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 > > athttp://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 > athttp://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.
