I have round about 4 Mio records in my index and I found out that filtering by specific attributes was quite slow using 0.9.9. Looking at the query log I found lines like these:
[Thu Sep 23 12:56:05.305 2010] 0.271 sec [scan/4/rel 111 (0,20)] [track_core] So I tried upgrading to sphinx 1.1-beta and the same queries where much faster: [Thu Sep 23 12:41:32.287 2010] 0.004 sec [all/3/rel 111 (0,20)] [track_core] Is that a specific improvement in 1.1 or can I make 0.9.9 to not "scan" the whole index as well? Thanx, Tobi -- You received this message because you are subscribed to the Google Groups "sphinx-dev" group. To post to this group, send email to sphinx-...@googlegroups.com. To unsubscribe from this group, send email to sphinx-dev+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sphinx-dev?hl=en.
