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.
