Graham Chiu wrote:
>
> In article <p04310103b54cde3dbe12@[209.27.56.93]>, J. Atwood
> <[EMAIL PROTECTED]> writes
> >As for the database, MySQL is hands down the fastest, but certainly not the most
> >robust in terms of features. Oracle is great if you have $10,000 and a full time
> >DBA but PostgreSQL 7.0 is really your best bet. You might also want to take the
> >money you were going to spend on the DB2 and put it right back into DB1 and
> >house everything there. Just get a beefy machine, RAID it up for redundancy and
> >call it a day.
<deletia>
> And since for sessions, all you really want is speed without
> any fancy SQL transactions, then MySQL for the session data seems an
> appropriate use.
I seem to recall from the MySQL vs Postgres thread a while ago that
MySQL was fastest in mostly-reading situations, whereas Postgres was far
better when there is quite a lot of writing as well as reading.
If this is true, the Postgres should be a better choice for a
session-data DBMS.
Of course, the *right* way to find out is to run a benchmark :-)
--
Steve Alexander
Software Engineer
Cat-Box limited
_______________________________________________
Zope maillist - [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
** No cross posts or HTML encoding! **
(Related lists -
http://lists.zope.org/mailman/listinfo/zope-announce
http://lists.zope.org/mailman/listinfo/zope-dev )
