Peter A. J. Pilgrim commented:
> 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.
PostgreSQL had a short thread on this:
http://marc.theaimsgroup.com/?l=postgresql-general&m=102987283829569&w=2
You do want to follow the link to infoworld in this post, BTW
> 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 ?
You'd have to follow a couple of links from the one above, so --
http://www.infoworld.com/articles/hn/xml/02/08/14/020814hnmcnealyint.xml
about half-way down the page.
--
Joel Rees <[EMAIL PROTECTED]>
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
