AKAIK it would be completely possible to develop a new sdbc driver to
connect *directly* to MySQL, just like the case you mention with
PostgreSQL, with no need to use ODBC or JDBC.
Well... now that Sun spend u$s 1 billion on MySQL I wonder if some
MySQL developers can work together with the Base team, as resources as
few (AFAIK only people working in Base are three: fs, oj, msc).
That could of been done 2 years ago.
Besides the file-format-issue (unknown to the simple user), Base's
performance issues are often blamed to the Java-nature of HSQLDB, so
would a pure C++ application have a better performance than a
Java-based one?
Yes and no - I got a call from a customer last week wanting their money
back, after 3 days with a Base application - why? Performance - They run
Kubuntu 7.1 ( the distro version of OO.o ) and the performance on a
really simple database with the embedded database was crazy slow. I went
there and they where right, a Compaq 2.4 Ghz Intel 4, 512 Meg Ram and
opening the primary form was over 12 seconds - that was a form against a
single table with 2 listboxes and 105 records in the main table. A
report builder report - was taking over half a minute to just come up.
The culprit was Java ( sort of )- I should say gjc ( I think that is the
right name ) - First they where not going to give up the distro version
or OO.o so forget that, they need some of the features thast OO.o just
doesn't have yet. - but what they did allow was for me to replace the
java runtime with the actual SUN JRE - now the form opens in about 3
seconds, and the report is on the screen and finished in under 10 seconds
The bottom line is if your are hearing from Linux users that Base is
incredibly slow take a look at which java they are using, it matters.
Drew
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
