I was wondering the same thing, there don't seem to be many. It is exceptionally slow to display the first page after the login.
But that should only be a problem if there's a whole heap of data in there; what's the largest table? Also, my question about the RAM was actually how much is being used; not what the total capacity is -- it's hard to tell whether swapping is the problem or not without knowing that. So, how much does each passenger process use; how much is the DB using? How much do they use when you've just started them, vs when you've done a few requests? I don't know much about the Maria storage engine; but it does seem like it might well be the DB rather than Rails. I had a quick look through your code, but I couldn't see any huge errors; it looks like the sort of code that could run well. (There are a few things I'd change, but not much to do with performance.) On Thu, Apr 22, 2010 at 15:10, Jonathan Clarke <jonat...@beilabs.com> wrote: > 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. >> 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. > -- 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.