There exists Oracle connection pool daemon and django backend to utilize it. Check http://code.google.com/p/pyorapool/
Connecting to Oracle is rather slow operation and if possible you really like connection pooling. Though even I'm using ajax based system to rather db intensive app that gets quite lot of request so far I've not seen necessity to use connection pooling. Normal roundtrip (django server is on different hardware than Oracle, connected using gigabit backplane) normal roundtrip is around 350ms. More speed could be obtained with Django caching mechanisms. Rafael Ferreira kirjoitti: > If you are on 11g you can try to use this: > > http://www.oracle.com/technology/tech/oci/pdf/oracledrcp11g.pdf > > otherwise you can look for something like mysqlproxy for oracle (if such > thing exist). > > The real question here tho is why do you care so much about reusing > connections? I can tell you that connection pooling is not all that is > cracked up to be. > > - raf > > On Mon, Sep 14, 2009 at 6:18 AM, lfrodrigues <[email protected] > <mailto:[email protected]>> wrote: > > > Hello, > > I'm not sure this is possible but I would to save a oracle connection > across several requests (like I do with a normal object) > > I would like to: > > if 'object' in request.session: > do stuff > else: > import cx_Oracle > conn = cx_Oracle.connect(constring) > request.session['object'] = conn > do stuff > > Since this doesn't work I thought about a global variable on > settings.py but that only works on de dev server. Apache uses multiple > processes so the global variable has different values depending of the > process. > > Any ideas how to keep a persistent connection across requests? > > Thanks > > > > > > -- Jani Tiainen --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---
