persistent db conn
luigi monaco
zdys at zdys.de
Sat Mar 22 06:41:23 EST 2003
hi clp,
i am new to python so please excuse me if the questions asked have
already been discussed, in this case just give a pointer.
i am playing around a bit with python(<50 lines of code 'til now).
found that it looks like a fairly readable and powerful scripting
language.
it also looks like s.th. wonderful to do server side http processing. so
i built the typical hello world, then some nav. over file hierarchy
stuff that does configurable html inclusion etc.
so far so good. i found mod_python for apache² and think that speed now is
acceptable.
actualy i am trying to understand how to build a fast db conn¹. basically
this means having a thread running with an existant conn to db, listening
for requests. at least this is what i would expect it to be - right?
so my question is:
[] is there a different and/ or faster way to do db conns for mass
requests?
[] would i launch a thread in the apache python handler, or better start
the thread before starting apache - how would i use this in the fastest
way? would i use sock - and then how? would i try to import the thread
and do method calls? ...
[] how would i have to implement this, keeping in mind that i want to use
different db for different named virtual hosts?
[] do i have to think about coherent access? if yes: how would i have to
build a short atomic lock or should i rely soley on mysql to do this?
probably this questions have been asked a lot of times. sufficient code has
been written. where?
thanks for your attention
luigi monaco
¹ in my case using mysql
² 1.3
More information about the Python-list
mailing list