Michael Bell wrote:
Yes, MySQL has a really own idea of indexes.
what do you mean by this? till now i didn't realized they would have quite a diffrent understanding of it...
The problem is that usually index namespaces are defined database wide. This means that you can say "drop index blabla". MySQL needs "drop index blabla on abc". The result is that we have to maintain extra code for MySQL.
The sequence stuff does not work too
you can simulate sequence stuff (with an own table or scripting, mysql has some abilities for scripting imho), otherweise, they have the ability to autoincrement numbered columns... which works normaly like a sequence...
I do exactly this with a seperate table. Nevertheless this is much more unclean (compared to other DBMS).
and SQL statement concatenation with ";" as seperator does not
this is new, usaly this should work with mysql too...
The problem is that concatenation allows to perform several SQL operations especially inserts in a very efficient way. This is interesting for the batch stuff where we need performance. finally I removed this code from OpenCA::DBI to get better maintainable code.
mysql is quite good speed optimized for simple queries thats why a lot of people use mysql instead of postgresql if they don't need the features (like subqueries, which didn't work for a long time), of postgresql or other full featured dbms, which are not included in mysql
The major issue which is not really clear for me is the transaction handling if you use more than one table. You can use different types of backends for tables in one database. So how should the transaction stuff work under such circumstances? This is the reason why I don't use mysql. If somebody can explain this to me then I would use mysql too.
Nevertheless the performance is impressive.
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
