I have setup TS on a dedicated Ubuntu box running Rails 3 and passenger. My DB is a MySQL DB located an a different machine, but in the same EC2 Geographical area so it should be fast-ish. I have 5 tables that are indexed, 4 of which have foreign keys on the main table. I have about 20000 records in this main table, and indexes on each of the foreign keys, :has fields, and where fields. There is also an index on the type column as it is an STI table.
First of all — Everything works. TS gives me great results, finds are fast, text searching across fields is fast and I am very happy with the performance. It is just taking very long to index the data and I am not sure if I am doing something wrong or have something setup a little funky for this. This setup with only 20k entries takes almost 1 hour to complete. I have increased RAM to 128M, tried to follow the guide to make indexing faster, but this still seems very slow. I have worked with Xapian before and on tables that were orders of magnitude larger, it was faster. Because sphinx and TS are just as good a Xapian, this leads me to believe something is wrong. As a sanity check, does this slow indexing with my setup sound normal? -- 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.
