On Thu, Jan 28, 2010 at 3:53 PM, Saravanan <[email protected]>wrote:
> I have Django installed in SUSE Linux with postgres. It is working > great. Kudos!!!! > I have an issue. I have total database structure containing more than > 100million rows. I have partitions and indexes. It is taking plenty of > time to load Django initially. I meant in minutes. I can take a coffee > break and a short workout schedule. Is there any ideas/links and other > resources to speed up the response time (Throughput) > For you information, I am looking at Cache and DB tunning. Any other > tricks with Django, anything you are familiar with it? > The first thing you should look at is what queries are being run. You might be running too many queries, or it might be that you need to add some indexes to your database. Try looking at django-toolbar. The fact that you have 100 million rows shouldn't really matter. -Doug > > -- > You received this message because you are subscribed to the Google Groups > "Django users" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]<django-users%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/django-users?hl=en. > > -- You received this message because you are subscribed to the Google Groups "Django users" 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/django-users?hl=en.
