Re: [Zope] SQLSession vs FSSession for ultra-high scalability and speed.

In article <39279A2F.BA5AED6D@cat-box.net>, Steve Alexander <steve@cat- box.net> writes

...

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.

For SQLSessions, you only write the session data once, and read multiple times. So, that would suit MySQL ? -- Regards, Graham Chiu gchiu<at>compkarori.co.nz http://www.compkarori.co.nz/index.php Powered by Interbase and Zope