Robert J. Sanford, Jr. wrote:
> For my money, or the lack thereof :), I would much rather use PostgreSQL or
> SAP DB than MySQL for both feature AND, believe it or not, performance
> reasons. One of the developers on the SourceForge project did a very nice
> comparison of how SF would run on both MySQL and PostgreSQL and he was very
> surprised at the results. You can read about it at:
> http://www.phpbuilder.com/columns/tim20000705.php3. Of course, he was using
> PHP instead of Struts :)
>
The article appears to be lauding MySQL features albeit 1999 on
some speed issues. I definitely miss the subselect SQL syntax which
is definitely useful with Oracle and Sybase.
MySQL 4.0 Beta is out and wait for it. Full Text Match capabilities.
Is this the end of Lucene or eSearch ? No. I like the bit about
not returning the whole table of data if the query matches more
than half the number of rows in the database table.
As for LargeResultSets I don't think Sybase has rowset limit
optimisation. Oracle I know a ROWID reverse keyword or is it
ROWINDEX I cant remember.
> For my own personal work I chose PostgreSQL for several features that
> MySQL - nested queries, views, triggers and stored procedures being the
> biggies. Transactions weren't available with MySQL at the time I made my
> decision but, even with their current level of support for transactions, I
> cannot conceive of doing without the other features, views and stored
> procedures especially.
>
> And that is why I don't understand Sun's push for MySQL. Are there any
> enterprise level projects (heck, even department level projects) that you
> don't want to use views and stored procedures with?
>
Sun's push for MySQL. Where did you read about this ?
> rjsjr
>
Well ISP / Java WebHoster only support MySQL, so I got no choice.
--
Peter Pilgrim +-----\ +-++----++----+
Java Technologist | | | || || | 'n' Shine
| O | | || --+| ---+
/\ | ._ / | | \ \ | |
/ \ | | \ \ | |+-- || ---+ A new day
/_ _\ "Up" | | | | | || || | is coming
|| +-+ +-+ +-++----++----+
<home page="http://www.xenonsoft.demon.co.uk/"; />
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
