Andrew Jensen wrote:
Hi Drew, hi Juraj, and sorry for diverting the thread with my earlier
comments.
Tony Galmiche from the French n-l list did a lot of performance testing
on copying table data from mysql to Base/HSQLDB tables, and summarized
this in a report that was in a bug issue somewhere, except that I can't
find it now of course :-( The conclusion was that things have improved
slightly, but as soon as you start to copy thousands of records, you
kiss goodbye to performance.
A bit of rummaging in IZ :
http://www.openoffice.org/issues/show_bug.cgi?id=31833
Although this initially related to linked tables, there is also an
example of copying a single table with indexes to a Calc sheet.
Test configuration :
Client machine : Celeron 700 with 256Mb Ram
Server : XEON 1.0 Ghz with 512Mb Ram
Table with 59000 records and 6 non-indexed fields
To carry out the test, a data transfer corresponding to 4400
records was made into a Calc sheet :
HSQLDB in standard mode : 32.3s to transfer 4400 records into Calc
HSQLDB Client-Server mode : 32.3s.
MySQL in Client-Server mode via ODBC : 1.8s
MySQL in Client-Server mode via JDBC : 34.8s
Sqlite locally via ODBC : 1.7s.
So MySQL is 18 times faster than HSQLDB for the same operation.
MySQL is also 19 times faster with an ODBC driver than with a JDBC
driver :-(
Sqlite is as fast as MySQL via ODBC
It has to be said that these results were obtained with OOo2.0, and
would probably benefit from being tested again. Although I was the
reporter on this issue, I merely translated the reports from other users
and confirmed, so I don't have the datasets to retest. I'll ask around
on the n-l list to see if we can try stick something into IZ for Frank
for when he comes back from vacation.
Alex
Alex
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
