Anyone else have any ideas? I've implemented a fair chunk of memcached to alleviate the problem, but the initial issue still exists in that I'm seeing significant DB time on an app with a datasize of under a meg.
N On Thu, Apr 15, 2010 at 8:29 PM, Jared Brown <[email protected]> wrote: > 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%[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%[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%[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.
