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.
