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 -~----------~----~----~----~------~----~------~--~---
