I've been playing a little with the idea of a project with a Java front
end and some sort of Linux backend database. I just want some
confirmation of what I have seen in a very little bit of tinkering-
mysql - seems to be quite fast, has good performance with jdbc.
No transactions, no stored procs or triggers.
Has foreign keys
Costs, but not much
Postgres - seems awfully slow - I installed 6.4.2 and tried a couple of
things but it just seems SLOW when dealing with large numbers or records.
Transactions, stored procs, triggers, jdbc (slow but there).
Foreign keys only available via non DDL kludged triggers - not that
hard to do but not at all standard or portable.
Oracle - has everything, is fast - BIG $ to do it right
Enormous footprint
Any comments on these observations would be appreciated.
John Holland
-----------------------------------------------------------
Send a mail to [EMAIL PROTECTED] with
unsubscribe mysql [EMAIL PROTECTED]
in the body of the message to unsubscribe from this list.
