If there's only one record, then it shouldn't matter what your range step is, because Sphinx finds the smallest and largest ids available - which in this case, are the same number.
Do you have all the same database indexes on your test db and development db? What's the output of rake ts:in RAILS_ENV=test? -- Pat On 09/10/2009, at 8:00 PM, rejeep wrote: > > I didn't mean that I was trying to index a single record. What I meant > was that I only had one record in the database for that test. So even > if there would be some high index, I guess it wouldn't take to long > anyway. > > If I try with this conf: > development: > sql_range_step: 1000 > production: > sql_range_step: 1000 > test: > sql_range_step: 1000 > > It's fast in development, but equally slow in test. > > It doesn't matter if I use 1000 or 10000000 for sql_range_step. > > On Oct 9, 5:43 pm, Pat Allan <[email protected]> wrote: >> Hi Rejeep >> >> Sphinx doesn't allow you to process a single record - only a full >> index. Also, do you have sql_range_step set for the test environment, >> as well as the development environment? >> >> -- >> Pat >> >> On 09/10/2009, at 11:53 AM, rejeep wrote: >> >> >> >>> Hi! >> >>> I have a site where I want to test the search. From the test I >>> create >>> the records and then create the index. But it's so slow that it >>> times >>> out. Yes, I'm using factories and I am aware of the id problem. But >>> first of all. In the test I only want to index 1 record. And the >>> id of >>> that usually is between 1000 - 5000. So that should not be such a >>> big >>> problem, right? And even thought I set sql_range_step, it is still >>> slow. >> >>> Since it is super fast in development the only thing I could think >>> be >>> the problem was the id's. But since it's not. Does someone has any >>> other suggestion? >> >>> If I skip creating any records before the indexing in the test. Then >>> the indexing is fast. >> >> > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
