array or database table

[bigtimslim]

I've made a site with a search feature that gathers and processes information from several feeds. The data from a search ends up being 6 columns by often hundreds of rows. This data only really needs to be stored for the session. I currently have it being stored in a multidimensional array. I will need to pass the array through different pages through sessions.

 

My question is, would it be better to somehow use a temporary mysql table for this information?

[deadonarrival]

You could always try sqlite... you can make a temporary table in memory and it's less unwieldy than a huge array.

 

If you have memory problems, a mysql database could work, but the problem is that you'd need a seperate table for each online user, and it would probably slow down appreciably.

 

I'd go with the sqlite route.