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.
