Session variables grow huge for no reason
Posted: Fri Mar 14, 2003 2:41 am
Hi there,
I hope you guys can help me.
I got a very slow database here so I decided to save the results of the select statements into a session variable for futher use. Right now the select returns 31000 rows, this is 5 MB in a flat file. I wanted to save the result array into a session variable.
Now, thats my problem; at the end of the script when PHP writes the session, it fails. I get a message that my allowed memory size is exhaustet.
The memory limit is 50 MB so I really don't know what PHP is saving there if I want to save 5 MB in an array.
The array has 2 dimensions, 10x31000 ($array['COLUMN'][index]).
Please help me ... this is driving me nuts!!
Thanks,
Stefanie
I hope you guys can help me.
I got a very slow database here so I decided to save the results of the select statements into a session variable for futher use. Right now the select returns 31000 rows, this is 5 MB in a flat file. I wanted to save the result array into a session variable.
Now, thats my problem; at the end of the script when PHP writes the session, it fails. I get a message that my allowed memory size is exhaustet.
The memory limit is 50 MB so I really don't know what PHP is saving there if I want to save 5 MB in an array.
The array has 2 dimensions, 10x31000 ($array['COLUMN'][index]).
Please help me ... this is driving me nuts!!
Thanks,
Stefanie