thx for your answer ;) i'm not the creator of the app, i'm taking it as it is and don't know every thing about it. after asking my mentor, it seems that the datas were originaly comming from fixtures, but actually we are now filling in the database by hand. So those first generated records where kept in the base and that's why they have so big ids.
after a reset, with smalls ids, my user model is indexed fast and without trouble :) thx On 12 mar, 14:16, Harold A. Giménez Ch. <[email protected]> wrote: > Is the data on the users table coming from fixtures, with the "hash" > (non-sequencial) IDs? If so, this is probably the problem. Sphinx indexes > data in batches, and uses the ID field to define which records to index. If > the IDs are sequencial, it will take all of the user records in one batch, > but otherwise you are causing the index process to query your DB multiple > times... > > On Thu, Mar 12, 2009 at 7:32 AM, GoNZoYuMo <[email protected]> wrote: > > > Hi, > > just a french (excuse my english) noob on rails & thinking sphinx > > (excuse my eventual mis understanding) > > > At this point I manage to index a model on my project but I went into > > trouble when trying to index another one. > > I have Animal, Group and User to be indexed > > Animals and Group are working fine and indexing is very fast > > > but it takes many times just for indexing just one field of the User > > model. > > Even if I index it alone, it takes arround 5 mins > > > I only have 31 records in database and I'm just indexing an email > > field (varchar) > > > define_index do > > indexes email > > > set_property :enable_star => true > > set_property :morphology => 'none' > > end > > > could you tell me what can make indexes take so long ? > > > One more thing, when I try to index the three models I get this : > > WARNING: DOCID_MAX document_id, skipping > > and 0 animals are indexed (I have 31 users, 20 groups and 31 animals) > > > indexing index 'animal_core'... > > WARNING: DOCID_MAX document_id, skipping > > collected 0 docs, 0.0 MB > > collected 0 attr values > > sorted 0.0 Mvalues, nan% done > > total 0 docs, 0 bytes > > total 0.012 sec, 0.00 bytes/sec, 0.00 docs/sec > > indexing index 'animal_delta'... > > collected 0 docs, 0.0 MB > > collected 0 attr values > > sorted 0.0 Mvalues, nan% done > > total 0 docs, 0 bytes > > total 0.010 sec, 0.00 bytes/sec, 0.00 docs/sec > > distributed index 'animal' can not be directly indexed; skipping. > > indexing index 'group_core'... > > collected 20 docs, 0.0 MB > > collected 0 attr values > > sorted 0.0 Mvalues, 100.0% done > > sorted 0.0 Mhits, 100.0% done > > total 20 docs, 1987 bytes > > total 0.010 sec, 198700.00 bytes/sec, 2000.00 docs/sec > > distributed index 'group' can not be directly indexed; skipping. > > indexing index 'user_core'... > > WARNING: DOCID_MAX document_id, skipping > > collected 3 docs, 0.0 MB > > collected 0 attr values > > sorted 0.0 Mvalues, 100.0% done > > sorted 0.0 Mhits, 100.0% done > > total 3 docs, 64 bytes > > total 252.266 sec, 0.25 bytes/sec, 0.01 docs/sec > > distributed index 'user' can not be directly indexed; skipping. > > > here I got only 3 users and the 20 groups indexed. > > When I only try to index animals and groups I get all of them indexed. > > > I read another post dealing with this issue and big ids seems to be > > the source of the problem : > > Animal ids are from 2114106538 to 2114106669 > > User ids are from 297021250 to 1830235262 > > Groups ids are from 40 to 61 > > > But why does it only append when I try to index Users ? > > > Thanks for helping and one more time, excuse my poor english ^^ --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
