My db reads and writes are very fast and I am running on the free database.
Jared On Apr 15, 10:03 am, Neil Middleton <[email protected]> wrote: > 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%252bunsubscr...@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 [email protected]. > > > > To unsubscribe from this group, send email to > > > > [email protected]<heroku%[email protected]> > > <heroku%[email protected]<heroku%252bunsubscr...@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 [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.
