I am struggling with sessions and large arrays.
I do a database query, and present a summary of the results on one page. The query can return up to 20,000 rows with about 20 elements each, which I keep in a multi-dimensional array.
The user can choose from a number of detail options which launches a second page.
To pass the result array to the second page, I pass it as a session variable. However time required to load the second page seems to be exponentially proportional to the size of the array.
Is there any more convenient way of making a large array available to a subsequent page. Passing it as a session variable seems way too slow.
Help will be appreciated.
SCR