Is there any indexes on those tables? Jonathan
On 22 April 2010 15:01, Joshua Partogi <jpart...@scrum8.com> wrote: > Hi Simon, > > The demo is running again now. The 2Gigs of RAM is my development > computer, the demo box runs on a VPS with 360MB RAM. > > If you want to see the DB schema, I have dumped it here: > http://github.com/scrum8/projexion/blob/master/db/development_structure.sql > > Thanks heaps mate. > > Kind regards, > Joshua > > > -- > http://twitter.com/scrum8 > > > On Thu, Apr 22, 2010 at 2:41 PM, Simon Russell <si...@bellyphant.com> > wrote: > > Hi Joshua, > > > > The app is _using_ 2 gigs on your demo box? Or you have 2 gigs of RAM? > > > > Seems like there shouldn't be any reason for it to be slow (sorry, > > it's still down, so I can't see if it's slow for me); I'd definitely > > have a look at your DB schema; see if the queries you're running are > > using an index. How many tables do you have, and how big is the > > largest one? > > > > On the passenger process limit, you can see how many it's using in > > 'top'; probably at this stage, I wouldn't necessarily fiddle with the > > limit, because that's likely to mask the real problem (the app being > > slow). > > > > Regards > > > > Simon. > > > > On Thu, Apr 22, 2010 at 13:58, Chris Herring > > <chris.herring.iph...@gmail.com> wrote: > >> I've never seen it do that, that sounds odd. > >> Monit is great tool to make sure all the stuff you need is up and > running, > >> you should check it out, or God. > > -- > You received this message because you are subscribed to the Google Groups > "Ruby or Rails Oceania" group. > To post to this group, send email to rails-ocea...@googlegroups.com. > To unsubscribe from this group, send email to > rails-oceania+unsubscr...@googlegroups.com<rails-oceania%2bunsubscr...@googlegroups.com> > . > For more options, visit this group at > http://groups.google.com/group/rails-oceania?hl=en. > > -- You received this message because you are subscribed to the Google Groups "Ruby or Rails Oceania" group. To post to this group, send email to rails-ocea...@googlegroups.com. To unsubscribe from this group, send email to rails-oceania+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/rails-oceania?hl=en.