[mod_python] mod_python slowness

I used pg / mod_python on my site too and it ran well.  My customer wanted
MySql though and we moved to it.  Thanks to DB-API 2.0 I had only a small
amount of code changes necessary...

jw

>>-----Original Message-----
>>From: Gregory (Grisha) Trubetskoy [mailto:grisha at modpython.org]
>>Sent: Tuesday, May 13, 2003 12:22 PM
>>To: alex at neteconomist.com
>>Cc: mod_python at modpython.org
>>Subject: Re: [mod_python] mod_python slowness
>>
>>
>>
>>Hmm... Well I'm kinda short on ideas. If it's any reassurance 
>>- I'm using
>>pg with mod_python for a small project right now, and it's 
>>very very fast,
>>i.e. I am not aware of any problems with combination of mod_python and
>>postgresql.
>>
>>Grisha
>>
>>On Tue, 13 May 2003, Alex Turner wrote:
>>
>>>
>>> I'm pretty sure this is not a DNS problem.  I can break 
>>down each loop
>>> that calls the database, and it shows 0.7 seconds per row returning
>>> instead of like 0.03 seconds.  The dns servers are all configured
>>> correctly for both forward and reverse lookups, and I do 
>>not have the same
>>> problems in PHP (other the fact that PHP is crap compared 
>>to python - but
>>> it's not this slow).
>>>
>>> Alex Turner
>>> NetEconomist
>>>
>>> On Tue, 13 May 2003, Gregory (Grisha) Trubetskoy wrote:
>>>
>>> >
>>> > I'd first make sure it is not a DNS problem - probably 
>>the easiest thing
>>> > is to run tcpdump on port 53 to what DNS activity takes 
>>place when a
>>> > request comes in. Make sure that apache does not resolve 
>>host names, also
>>> > watch out for postgres using tcpwrappers to resolve host names for
>>> > incoming connections.
>>> >
>>> > Grisha
>>> >
>>> > On Tue, 13 May 2003, Alex Turner wrote:
>>> >
>>> > >
>>> > > I have a scripts that takes an XML document, munges it 
>>and turns it into
>>> > > HTML to be outputed to the user.  It's setup so that it 
>>will run either as
>>> > > a request handler in mod_python or as a stand alone 
>>application.  I am
>>> > > having extreme problem with the script being slow when 
>>running in
>>> > > mod_python.  I have done some timings, and it is 10-20 
>>times slower
>>> > > that it is standalone.  The program makes calls to a 
>>Postgresql database
>>> > > using the stock pg module.  The system is running 
>>mod_python 3.0.3
>>> > > w/apache 2.0.43.  I just upgraded to mod_python 3.0.3 
>>to see if that would
>>> > > help and it didn't.  Everything else is stock RedHat 
>>8.0 - python-2.2.1-17.
>>> > >
>>> > > I can't seem to use the profiler to narrow down the 
>>problem at all because
>>> > > I can't seem to figure out how to execute the profiler 
>>on a function that
>>> > > takes arguments, and all the functions take at least 
>>the HTTP request
>>> > > object as an argument, which makes it hard to use the 
>>python profiler.
>>> > > Even so the script runs fine stand alone.  The one page 
>>I am looking at
>>> > > goes from 2.2 seconds to 23 seconds.
>>> > >
>>> > > Has anyone had any similar issues?
>>> > >
>>> > > Alex Turner
>>> > > NetEconomist
>>> > >
>>> > > _______________________________________________
>>> > > Mod_python mailing list
>>> > > Mod_python at modpython.org
>>> > > http://mailman.modpython.org/mailman/listinfo/mod_python
>>> > >
>>> >
>>> > _______________________________________________
>>> > Mod_python mailing list
>>> > Mod_python at modpython.org
>>> > http://mailman.modpython.org/mailman/listinfo/mod_python
>>> >
>>>
>>
>>_______________________________________________
>>Mod_python mailing list
>>Mod_python at modpython.org
>>http://mailman.modpython.org/mailman/listinfo/mod_python
>>