How large are your tables? Are you doing joins? On Apr 15, 3:37 am, Neil Middleton <[email protected]> wrote: > Nope, everything is by id or by an index > > > > On Wed, Apr 14, 2010 at 11:30 PM, Carl Anderson <[email protected]> wrote: > > One thing that may or may not matter in your case but might be worth > > mentioning, do you do any searches by anything other than id? Did you add > > indexes for those other columns? > > > Carl > > > On Wed, Apr 14, 2010 at 3:21 PM, Neil Middleton > > <[email protected]>wrote: > > >> I've an app that I've just deployed to Heroku (http://www.boxfileapp.com) > >> and I have some concerns about the performance of the database. > > >> The app is only running on one dyno at the moment as the load (if you can > >> call it that) is miniscule. However, one thing I have noticed from within > >> RPM is that the database is accounting for around 60% of the total time for > >> the app. > > >> Given that there is a tiny amount of data in the app, and the queries are > >> no more complicated than simple selects, this is a little concerning. > > >> Is this because the app is on one dyno perhaps and the DB gets > >> 'switched-off' when it's not in use as the dyno would be? Or is there > >> something else at play? > > >> Sample RPM chart here: > >>http://skitch.com/neilmiddleton/n67qw/database-performance > > >> Neil > > >> -- > >> You received this message because you are subscribed to the Google Groups > >> "Heroku" group. > >> To post to this group, send email to [email protected]. > >> To unsubscribe from this group, send email to > >> [email protected]<heroku%[email protected]> > >> . > >> For more options, visit this group at > >>http://groups.google.com/group/heroku?hl=en. > > > -- > > You received this message because you are subscribed to the Google Groups > > "Heroku" group. > > To post to this group, send email to [email protected]. > > To unsubscribe from this group, send email to > > [email protected]<heroku%[email protected]> > > . > > For more options, visit this group at > >http://groups.google.com/group/heroku?hl=en.
-- You received this message because you are subscribed to the Google Groups "Heroku" 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/heroku?hl=en.
