As an add-on to this, does anyone know if one could use MySQL HEAP (memory resident) tables for the session table?
--Jon Robison Rob Bloodgood wrote: > > > I am using Apache::Session with Postgresql. Unfortunately I had > > never worked with a huge amount of data before I started to program > > something like a (little) web application. I happily packed > > everything in the "session"(s-table) that might be of any use. It > > hit me hard that it takes a veeerrrry long time to get all the stuff > > out of the "session"(s-table) each time the client sends another > > request. > > Sorry if this is obvious, but > do you have an index on your sessions table, on the sessionid column? > Because, without an index, PG will have to do a full table read for each > request. Which means the more sessions you get, the slower each lookup is > going to be. Whereas, if you index SESSIONID (or SESSION_ID or whatever it > is), it can go right to the row in question and return it immediately. > > L8r, > Rob > > #!/usr/bin/perl -w > use Disclaimer qw/:standard/;
