On Mon, Jul 27, 2009 at 10:44 AM, Miller,
Terion<tmiller@xxxxxxxxxxxxxxxxxxxx> wrote:
> Well there are currently about 17000 records in the db, and my manager wants to have it only pulling in 1000 at a time as a session range
> And why do my code snippets always look so messed up , I put them in using the rich text or html settings in my Entourage mail...
> They look fine when I send them and then crazy when I see them on a post reply...
> Anyways...it's one of those mondays where when we left on Friday all our pages were working brilliant and now they are all doing strange things, like trying to save instead of open
> And boss thinks it's the server strain and we need ranged sessions...would my thinking on using the foreach(range work though?
>
>
>
> On 7/27/09 9:34 AM, "Bastien Koert" <phpster@xxxxxxxxx> wrote:
>
> On Mon, Jul 27, 2009 at 10:30 AM, Miller,
> Terion<tmiller@xxxxxxxxxxxxxxxxxxxx> wrote:
>> I want to store only 1000 records at a time in the session variable thought I could use a range(1,1000....
>>
>> How would you do this, store the first 1000 , then the second on refresh etc
>>
>> My snippet so far
>>
>> -----------------------
>> // Process all results into $_SESSION array $position = 1; while ($row = mysql_fetch_array($result)) { $_SESSION['fullRestaurantList'][$position] = $row; $position++; foreach(range('1','1000') as $c){ ($position == $c)
>> $_SESSION['totalNumberOfRestaurants'] = $c; } }
>>
>> --
>> PHP General Mailing List (http://www.php.net/)
>> To unsubscribe, visit: http://www.php.net/unsub.php
>>
>>
>
>
> Teri,
>
> Do you really need that data to persist? This will not scale effectively.
> --
>
> Bastien
>
> Cat, the other other white meat
>
>
>
I would page the data with the LIMIT call as Jim suggested. What is
the user doing with 1K records and how are they getting 1K records?
--
Bastien
Cat, the other other white meat
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
