Webware for Python

Hi

I'm a webware beginner.
I would like to use sqlobject with webware and kid.

I have a question concerning database connections managment.
How do I leave connections open between requests? Is there a document 
somewhere on the website?
In the website, I've seen that there are awake() and sleep() method for 
different object levels.
But when I make a print inside these (in a class derivating from Page), 
awake and sleep are called at all transactions.
I still don't understand what are these methods for (except for ease of 
derivation)

Reading the webware doc and website, I found nothing to take care about 
external connections handling.
Do I have to manage my own opened connections pool which is accessed by 
all threads concurrently?
Should there be a connection per thread?
Is there a Thread instance, so I can store a connection handler?

Thanks for your help.

Re: [Webware-discuss] How to manage database connections efficiently? From: Christoph Zwerschke <cito@on...> - 2006-03-09 12:29 > Reading the webware doc and website, I found nothing to take care about > external connections handling. > Do I have to manage my own opened connections pool which is accessed by > all threads concurrently? > Should there be a connection per thread? > Is there a Thread instance, so I can store a connection handler? There are two possibilities. Either as you suggested, you create one connection per thread, or you use a connection pool. The former makes sense when you configure Webware in AppServer.config with a fixed number of threads. If it is configured dynamic, so that threads are constantly created and destroyed, it is better to use the connection pool approach. MiscUtils.DBPool provides a simple connection pool. DBUtils (www.w4py.org/DBUtils) provides a more sophisticated solution and support for both, connection pool and thread affine connections. -- Christoph

Re: [Webware-discuss] How to manage database connections efficiently? From: <mpalmer@sc...> - 2006-03-09 15:17 It may also depend on what database you are using. With MySQL, I have not seen any speed-up when using a pool, so I've done away with it and just create a new connection each time. Quoting Christoph Zwerschke <cito@...>: > > Reading the webware doc and website, I found nothing to take care about > > external connections handling. > > Do I have to manage my own opened connections pool which is accessed by > > all threads concurrently? > > Should there be a connection per thread? > > Is there a Thread instance, so I can store a connection handler? > > There are two possibilities. Either as you suggested, you create one > connection per thread, or you use a connection pool. The former makes > sense when you configure Webware in AppServer.config with a fixed number > of threads. If it is configured dynamic, so that threads are constantly > created and destroyed, it is better to use the connection pool approach. > > MiscUtils.DBPool provides a simple connection pool. DBUtils > (www.w4py.org/DBUtils) provides a more sophisticated solution and > support for both, connection pool and thread affine connections. > > -- Christoph > > > ------------------------------------------------------- > This SF.Net email is sponsored by xPML, a groundbreaking scripting language > that extends applications into web and mobile media. Attend the live webcast > and join the prime developer group breaking into this new coding territory! > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642 > _______________________________________________ > Webware-discuss mailing list > Webware-discuss@... > https://lists.sourceforge.net/lists/listinfo/webware-discuss > ---------------------------------------- This mail sent through http://www.mywaterloo.ca

Re: [Webware-discuss] How to manage database connections efficiently? From: Christoph Zwerschke <cito@on...> - 2006-03-09 15:33 > It may also depend on what database you are using. With MySQL, I have not seen > any speed-up when using a pool, so I've done away with it and just create a new > connection each time. Even more, it depends on which type of queries you are using. Read-only, read-write, transactions composed of several sql commands, long-running queries etc. -- Christoph

Re: [Webware-discuss] How to manage database connections efficiently? From: Ian Bicking <ianb@co...> - 2006-03-09 16:12 Sophana Kok wrote: > I'm a webware beginner. > I would like to use sqlobject with webware and kid. If you are using SQLObject, it handles the connections for you. -- Ian Bicking / ianb@... / http://blog.ianbicking.org

Re: [Webware-discuss] How to manage database connections efficiently? From: Christoph Zwerschke <cito@on...> - 2006-03-09 16:47 > If you are using SQLObject, it handles the connections for you. I haven't tried out SQLObject so far, but that sounds like I should give it a try. How does this work? Does it use a connection pool? -- Chris

Re: [Webware-discuss] How to manage database connections efficiently? From: Ian Bicking <ianb@co...> - 2006-03-09 16:52 Christoph Zwerschke wrote: >> If you are using SQLObject, it handles the connections for you. > > > I haven't tried out SQLObject so far, but that sounds like I should give > it a try. How does this work? Does it use a connection pool? Yep. BTW, in SQLObject 2 / sqlapi I actually am borrowing some code from DBUtils to split the pooling out into a separate layer: http://svn.sqlobject.org/sqlapi/trunk/sqlapi/connect Though I haven't figured out quite how it should work. For instance, SQLite connections can't be pooled, they need to be allocated per-thread. And I'm not sure if pooling is generally good or not -- per-thread connections seem a bit safer and otherwise just as good. -- Ian Bicking / ianb@... / http://blog.ianbicking.org

Re: [Webware-discuss] How to manage database connections efficiently? From: sophana <sophana78@ya...> - 2006-03-09 22:16 Ian Bicking wrote: > Sophana Kok wrote: > >> I'm a webware beginner. >> I would like to use sqlobject with webware and kid. > > > If you are using SQLObject, it handles the connections for you. > > Ok thanks, I just had a look in the source, seems that I just need to set the sqlhub.processConnection global in one of my modules (not in a method), then a connection will be created per thread. Nothing to do. (very nice indeed) But what if the connections get broken, will they restart automaticaly? About speed, what (free) database is the fastest? I need to sort with the distances from one point. I don't know yet the tables sizes, but they could be big (I may need scalability). I've heard that postgreSQL can be better than mysql. What do you think?

1 message has been excluded from this view by a project administrator.