Total DB size is 28K so far ;) On Thu, Apr 15, 2010 at 2:55 PM, Jared Brown <[email protected]> wrote:
> 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]> > <heroku%[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]> > <heroku%[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.
