Re: Imposing a range on what is stored in a session variable

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