On Mon, Jul 27, 2009 at 10:44 AM, Miller,
Terion<tmil...@springfi.gannett.com> 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" <phps...@gmail.com> wrote:
>
> On Mon, Jul 27, 2009 at 10:30 AM, Miller,
> Terion<tmil...@springfi.gannett.com> 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
