[EMAIL PROTECTED] wrote:
OK, I am using mysql, I have enabled the "slow query log" which logs all queries that are not indexed or take longer than 1 second. I can not see any query to the data base when I perform the create CSR task. But I can see queries reported if I query certain tables in the data base directly. I can see "select * from data" reported in the log. But nothing is reported if I query one of the new tables, eg, "select * from sequesnce_csr".
Is this because you have set up indexes on these new tables ?
Yes, MySQL has a really own idea of indexes. The sequence stuff does not work too and SQL statement concatenation with ";" as seperator does not work too. I commited the updated module 1 minute ago. Nevertheless it looks like MySQL is 25 % faster than PostgreSQL but I don't know anything about the transaction handling of my MySQL.
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
