You're creating a contrived test though. If you really wanted the count of users you'd probably do a "count" in the database itself.
I don't think you're getting any valuable data on your application's actual performance: you basically made a view that just loops over 9000 items. Of course it will be slow if you keep reloading it! Try using a tool like "ab"(Apache Benchmark) or tsung to hit real application pages quickly and concurrently. On Mon, Apr 16, 2012 at 4:41 PM, Yarden Sachs <yrd...@gmail.com> wrote: > what perpesfully used. for heavy system performance > > On 16 באפר 2012 23:38, "andrea mucci" <cingus...@gmail.com> wrote: >> >> 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. > > -- > 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.
