Hi Rajesh What versions of Thinking Sphinx, Rails and - most importantly for datetime deltas - Sphinx are you using? 0.9.8? 0.9.8.1? 0.9.9rc1? 0.9.9rc2?
Your setup seems correct - but you will still need to do a full re- index regularly. Any approach to delta indexing does not remove that need. As for merging, the datetime delta code takes care of that, so it's not something you need to worry about. The .tmp files may be related to your issue though. Cheers -- Pat On 05/06/2009, at 1:38 AM, Rajesh farkare wrote: > Hi Pat, > > I am using thinking sphinx in one of my applications which is search > based. It has lot of input every 15 minutes and needs to be indexed. > > > In my do_index I have: > > set_property :delta => :datetime, :delta_column > => :updated_at, :threshold => 22.minutes > > I run the cron for delta 'rake thinking_sphinx:index:delta > RAILS_ENV=production' every 20 minutes. > > > But the new data is not getting indexed in expected time.I see the > new data in search results after a interval of 4-5 hours. > Also, I have to explicitly reindex completely at times. > > Not getting where exactly the problem is, am I missing anything? Do > I need to do merge? I dont see 'merge' task in my rake list. > > > Also, I found some .tmp files created in the sphinx folder.I suspect > if these are related to the problem in some way. > Where can I find the significance of all these file types? > > > > When I do > > ls -l db/sphinx/production: > > I see the following. > > > total 259136 > -rw-r--r-- 1 root root 7008576 Jun 4 09:20 item_core.spa > -rw-r--r-- 1 root root 7102080 Jun 5 00:40 item_core.spa.tmp > -rw-r--r-- 1 root root 96134630 Jun 4 09:20 item_core.spd > -rw-r--r-- 1 root root 0 Jun 5 00:40 item_core.spd.tmp > -rw-r--r-- 1 root root 347 Jun 4 09:20 item_core.sph > -rw-r--r-- 1 root root 2687497 Jun 4 09:20 item_core.spi > -rw-r--r-- 1 root root 0 Jun 5 00:40 item_core.spi.tmp > -rw-r--r-- 1 root root 0 Jun 3 07:40 item_core.spk > -rw------- 1 root root 0 Jun 5 00:40 item_core.spl > -rw-r--r-- 1 root root 2628216 Jun 4 09:20 item_core.spm > -rw-r--r-- 1 root root 2097152 Jun 5 00:40 item_core.spm.tmp > -rw-r--r-- 1 root root 143840229 Jun 4 09:20 item_core.spp > -rw-r--r-- 1 root root 0 Jun 5 00:40 item_core.spp.tmp > -rw-r--r-- 1 root root 94240 Jun 5 00:40 item_delta.spa > -rw-r--r-- 1 root root 1302450 Jun 5 00:40 item_delta.spd > -rw-r--r-- 1 root root 347 Jun 5 00:40 item_delta.sph > -rw-r--r-- 1 root root 171537 Jun 5 00:40 item_delta.spi > -rw-r--r-- 1 root root 0 Jun 3 07:40 item_delta.spk > -rw------- 1 root root 0 Jun 5 00:40 item_delta.spl > -rw-r--r-- 1 root root 35340 Jun 5 00:40 item_delta.spm > -rw-r--r-- 1 root root 1923426 Jun 5 00:40 item_delta.spp > > > > -- > thanks & regards > > Rajesh Farkare > Pune > > +91-9890301768 > > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
