I've got a case of very slow indexing - 111 seconds to index 9 documents. It's not really thinking sphinx that is responsible for this part anyway - but just looking for any tips or ideas.
- on my laptop it runs fine, e.g.: indexing index 'user_delta'... total 2 docs, 68 bytes total 0.048 sec, 1425.43 bytes/sec, 41.92 docs/sec - on the production server one time it ran like this: indexing index 'user_delta'.. total 9 docs, 320 bytes total 111.667 sec, 2.87 bytes/sec, 0.08 docs/sec - and another like this: indexing index 'user_delta'... total 14 docs, 533 bytes total 8.589 sec, 62.06 bytes/sec, 1.63 docs/sec the indexer is running on seperate box to the db - the db server is a very fast database server (SAS disks etc) so the hardware should be fine, but the load on it is surprisingly high when running the indexing. I ran a MySQL EXPLAIN command on the generated SQL configuration and it shows all indexes being used. so, yeah, any experiences people might have that could help would be much appreciated. cheers! -- 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.
