From: Ralf S. <sch...@tt...> - 2004-12-02 16:52:58
|
I'm currently running a "roundup-admin reindex" on a database where I've imported around 100.000 issues with a custom schema. I have added the "indexme" parameter to around 10 strings in the schema. The reindex is now running for 5 *days* without an end in sight. Before I look into the code: - Is the reindexing really that slow? - Are there improvements in the upcoming 0.8? - How can I help to improve the situation :-) Note that I have imported the data via a hand-coded script that uses the same interface as the roundup-admin import would use. Since importing took very long with all the indexed strings, I have commented out the indexes during import and re-enabled them afterwards, hoping to get better performance indexing all in one go. Importing with all the indexme strings took about 20 seconds for 100 items while with disabled indexmes it took about .5 seconds. If there are improvements with .8 I'll gladly test my import and indexing with that version -- if it is sufficiently stable to try. Ralf -- Dr. Ralf Schlatterbeck, Senior Software Consultant TTTech Computertechnik AG, http://www.tttech.com Schoenbrunner Strasse 7, A-1040 Vienna, Austria Tel.: +43 1 585 34 34-0, Fax: +43 1 585 34 34-90 |