I'm experiencing the same increase in time when building my index after activating delta index (with delayed_job). I have a index on my delta column.
Before it took a few minutes. Now it stops at: indexing index 'article_core'... After an hour or so it continues to build the index with the same speed as before using delta index. I'm using postgres and the 0.9.9 branch of TS with Sphinx 0.9.9-rc2 /David > > 2) I attempted to use the delta mechanism but after added the delta > > > column > > > and the set propertly :delta => true into my define_index section of > > > my > > > model, indexing for the first time never completed. I Hvae one table > > > with > > > close to 7 million rows that takes maybe a couple of minutes to index > > > but > > > after adding the delta and trying to create a fresh index, i let it > > > run for > > > 3 hours and it never even got to the point in the console output that > > > said > > > it was processing. It just showed the initial "creating index...". > > > > Is there an index on your delta column? > > > Doh! Forgot to add an index. That's gotta be it. Thanks! > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
