John Holland wrote:
> 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.
>
Just one thing--
MySQL does not have foreign keys.
--
Daniel Koch
American City Business Journals
http://www.amcity.com/
-----------------------------------------------------------
Send a mail to [EMAIL PROTECTED] with
unsubscribe mysql [EMAIL PROTECTED]
in the body of the message to unsubscribe from this list.
