So if you hit a page that is not active scafflod, active scaffold puts objects in the database? Sent from my Verizon Wireless BlackBerry
-----Original Message----- From: Sylvain <[email protected]> Date: Thu, 25 Jun 2009 23:56:42 To: ActiveScaffold : Ruby on Rails plugin<[email protected]> Subject: Re: Active Scaffold and active_record_session store Hi, yes i've put index in my session table My session table was 128Mb big yesterday with less than 400 objects. So the average is 300Kb. When I did some tests, I tried to do what was doing an avergae user and I have some sessions variables of more than 100Kb in few clicks. So the session table retrieve is getting higher and higher... In a page where there's no AS, I've got 26 var from active scaffold On 25 juin, 19:12, "G. Sobrinho" <[email protected]> wrote: > Do you have indices on session table? 3,5s is strange (too slow) > > 2009/6/25 Sylvain <[email protected]> > > > > > Hi all, > > I'm using intensively active scaffold in my web site. > > I figured out that the web pages were very long to come. Using Rack- > > Bug, I figured out that the problem was retrieving the sessions var > > from the DB (it took 3,5s to retrieve them) and most of them were for > > activescaffold. > > I'm using a lot conditions and constraint with a large number of ID > > (my DB hase more than 100K objects) and all of them where in the > > session store of the DB (that's why it's so long). > > Is there a way to avoid that (except launching regularly rake > > db:sessions:clear) because it's very annoying? > > Shall I use another session store? > > -- > Regards, > > Gabriel Sobrinho > E-mail: [email protected] > Phone: +55 31 8775 8378 > > Don't print this e-mail. The nature is thankful and your money also. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "ActiveScaffold : Ruby on Rails plugin" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/activescaffold?hl=en -~----------~----~----~----~------~----~------~--~---
