using aws ec2 & rds. so rolling out that. i monitor every query for high performance. but Users all is very simple query.
what do u think it could other than those? thanks for all the help On Monday, April 16, 2012 10:59:55 PM UTC+3, creecode wrote: > > Hello Yarden, > > On Monday, April 16, 2012 12:25:36 PM UTC-7, Yarden Sachs wrote: > > Hello, I am using django 1.3 on apache 2.* on windows server 2008. >> mysql 5.* >> >> When i try to access a view that does this: def view(request): >> len(User.objects.all()) return HttpResponse() >> >> i have about 9K results on that. i am doing len and not .count, >> because i want to test the server. >> >> the server becomes reaally slow. >> > > Are you running Django and MySQL on the same server box? If so then you > are possibly running into speed issues because of contention. There are > several Djagno configuration docs on the web that talk about using at least > one server for your app and another for your database. Another thing to do > is move static files onto their own sever. > > You might want to try django-debug-toolbar to examine your queries for > your webpages to see if you can do some optimization. I highly recommend > giving it a go! > > Of course there are many things one can do to make things faster but > you'll need to give us some more info about your setup before we can help > you more. > > Toodle-loooooooooooooo................. > creecode > -- You received this message because you are subscribed to the Google Groups "Django users" group. To view this discussion on the web visit https://groups.google.com/d/msg/django-users/-/gTlmPOgGsIkJ. To post to this group, send email to django-users@googlegroups.com. To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/django-users?hl=en.
