> 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/;
