High Traffic

2012-04-16 Thread Yarden Sachs
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

Re: High Traffic

2012-04-16 Thread Yarden Sachs
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(

Re: High Traffic

2012-04-16 Thread Yarden Sachs
zens-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

Re: High Traffic

2012-04-16 Thread Yarden Sachs
ofcourse... i am using django since dec 10, and now i dont know what to do On 16 באפר 2012 23:30, "Ramiro Morales" wrote: > On Mon, Apr 16, 2012 at 5:22 PM, Yarden Sachs wrote: > > i have 9000 rows. and using mod_wsgi on apache2. what am i doing wrong? > i > > tried

Re: High Traffic

2012-04-16 Thread Yarden Sachs
t; > 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&q

Re: High Traffic

2012-04-16 Thread Yarden Sachs
On Mon, Apr 16, 2012 at 2:25 PM, Yarden Sachs wrote: > > * COUNTING THE RESULTS IS NOT THE POINT > > ok, then that len(User.objects.all()) is not an appropriate benchmark, > right? > > what you're doing is a view that fetches all 9K records from the DB, > without any

Re: High Traffic

2012-04-16 Thread Yarden Sachs
n Mon, Apr 16, 2012 at 3:49 PM, Yarden Sachs wrote: > > when i try to do it from client, it takes 0.7 secs to come back with > > response, if try to do it from 10 parralel client, it takes 15 secs for > one > > http response! > > > well, if you do a heavy and memory i

Re: High Traffic

2012-04-16 Thread Yarden Sachs
thanks! have any advice for good performance? and profiling? On 17 באפר 2012 00:18, "CLIFFORD ILKAY" wrote: > On 04/16/2012 04:49 PM, Yarden Sachs wrote: > >> Sure, >> >> I experienced unknown performance issues(slow responses) when high >> traffic would h

Special SELECT and UPDATE for a field

2013-01-30 Thread Yarden Sachs
Hello, i want to create a field class for geometry (not using geodjango). here's the field code: http://pastebin.com/yADpZykJ i want 2 things i can't seem to do: 1. I want the select to wrap the column with MySql AsText() Function e.x. SELECT AsText(location) FROM addresses 2. I want to be able

Re: Special SELECT and UPDATE for a field

2013-01-31 Thread Yarden Sachs
(using=self.db).connection.cursor().cursor.cursor.connection if not Coordinates in connection.encoders: connection.encoders[Coordinates] = to_raw_sql return q i still cant do the select astext() please HELP! On Wednesday, January 30, 2013 10:14:57 PM UTC+2, Yarden Sachs

Re: Special SELECT and UPDATE for a field

2013-01-31 Thread Yarden Sachs
You can see in my paste that i already created a custom field for geometry field. On Thu, Jan 31, 2013 at 7:52 PM, Tom Evans wrote: > On Wed, Jan 30, 2013 at 8:14 PM, Yarden Sachs wrote: > > Hello, > > i want to create a field class for geometry (not using geodjango). >

Re: Special SELECT and UPDATE for a field

2013-01-31 Thread Yarden Sachs
very bad solution. but it worked. this was really difficult to do, there is no reason for django not to let me tell django to put in NOW() or AsText or any non literal string. On Wednesday, January 30, 2013 10:14:57 PM UTC+2, Yarden Sachs wrote: > > Hello, > i want to create a field clas