Re: django DB optimization

2013-03-05 Thread Rui Silva
Hi Subodh, 10k records isn't that much. Nonetheless you should test your application with high loads to assert if the database performance is an issue. If the test results show that the database performance may be a problem, you should check if the tables you use are properly indexed and loo

Re: django DB optimization

2013-03-05 Thread graeme
10,000 people does not sound like too heavy a load. How often will they check their schedules? If you are looking up items by day and user, then indices on day and (foreign key on) user should be enough to handle a much heavier load. If you do find you need caching, using Django's built in cach

Re: django DB optimization

2013-03-04 Thread Shawn Milochik
Rule #1: Measure first. Don't add any complexity to fix any bottlenecks until you know for a fact where they are. Once you know where one is, the solution will probably be fairly obvious. Caching, denormalization, etc. Come up with a way to stress-test your app and add measurements. -- You rece