First, what database platform do you use: MySQL or Postgres. MySQL has ways of logging slow queries (see /etc/mysql/my.cnf), this will give you an understanding of which queries are slow and you may be able to add indices where necessary. Secondly, if you use PHPmyAdmin it can tell you what tuning parameters need to be changed. You may want to do this on your development environment, not on production.
I have no experience with Postgres. But learning how to tune a database is something that you can learn thru the MySQL or Postgres channels. Sometimes an increase in table or buffer size can make a serious difference in database responsiveness. good luck. On Mar 7, 9:47 am, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote: > Sounds good. How does one go about profiling? Is there a tutorial or > something you can point me to? > > Also, I appreciate everyone's patience with these dumb and vague > questions. It's frustrating being a stupid newbie. > > For what it's worth, I have found some things, most notably that I was > - for whatever reason - cycling through every post for every topic > when I built the topic list. That might be slowing things down a bit. > > On Mar 7, 10:26 am, "James Bennett" <[EMAIL PROTECTED]> wrote: > > > On 3/7/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > > > I think the problem lies in the forum (a modified Myghtyboard install) > > > and in it's relationship to users. Since both forum posts and users > > > keeps growing, I wonder if I've created some sort of exponential > > > growth situation for myself. > > > Probably the first thing to do is start profiling to figure out where > > the time is actually being spent; without knowing where your > > bottleneck is, it's hard to suggest possible solutions. > > > -- > > "Bureaucrat Conrad, you are technically correct -- the best kind of > > correct." --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---
