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

Graham Chiu anon_emouse@hotmail.com
Sun, 21 May 2000 21:28:46 +1300


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