have you debugged the mysql query nginx+fgi work pretty well so is very very strange.
have you tried to test, other type of query result without len method? El 16/04/2012, a las 22:22, Yarden Sachs escribió: > i have 9000 rows. and using mod_wsgi on apache2. what am i doing wrong? i > tried to switch to nginx+fcgi. and tried ubuntu srrver as well. same results. > > any ideas? > > On 16 באפר 2012 23:18, "andrea mucci" <cingus...@gmail.com> wrote: > hi Yarden > > how many users have you in your database? > you use mod_fcgi or mod_python? ( more recommendable will be mod_fcgi or > mod_fcgid ) > > Django is framework that suppert very very large traffic. > you can see an example here > http://instagram-engineering.tumblr.com/post/13649370142/what-powers-instagram-hundreds-of-instances-dozens-of > > so, the most important think is configure well all the different component > around your project > like Apache2 ( big monster ), mod_fcgi etc…. > > cheers, > > > El 16/04/2012, a las 22:06, Yarden Sachs escribió: > >> 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. > > > -- > 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 > django-users+unsubscr...@googlegroups.com. > 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 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. -- 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 django-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/django-users?hl=en.
