Hi Chris,
nice situation - I played a little bit with indexes. I created four indexes on the new database before I import all the stuff and now the complete batchstuff needs only 60% of the time. I used the following indexes:
create index data_column_string_index on DATA(column_name, char_content); create index data_global_id_index on DATA(global_id); create index data_global_column_index on DATA(global_id, column_name); create index data_column_name_index on DATA(column_name);
Perhaps you find another index which we should integrate. "create index" is a standard SQL command. This makes the integration really easy.
Michael -- _______________________________________________________________
Michael Bell Humboldt-Universitaet zu Berlin
Tel.: +49 (0)30-2093 2482 ZE Computer- und Medienservice Fax: +49 (0)30-2093 2704 Unter den Linden 6 [EMAIL PROTECTED] D-10099 Berlin _______________________________________________________________
------------------------------------------------------- This SF.Net email is sponsored by: Sybase ASE Linux Express Edition - download now for FREE LinuxWorld Reader's Choice Award Winner for best database on Linux. http://ads.osdn.com/?ad_id=5588&alloc_id=12065&op=click _______________________________________________ OpenCA-Devel mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/openca-devel
