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 <neil.middle...@gmail.com>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 her...@googlegroups.com. > To unsubscribe from this group, send email to > heroku+unsubscr...@googlegroups.com<heroku%2bunsubscr...@googlegroups.com> > . > 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 her...@googlegroups.com. To unsubscribe from this group, send email to heroku+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/heroku?hl=en.
