> If all of the above is happening within one logical transaction (and, > I don't mean, a db transaction -- since you mentioned Apache, I mean, > a "job," a "click" from the user's point of view), you certainly can > and should open a single db connection, do everything you want to do, > close the db, and then return the result to the user. At least, that > is how I do it.
And if you open and close connection several times for one Apache request it will just hurt your performance. But if you do that only 2-3 times per request then you probably won't notice it until load on Apache server grows up to the certain level. Pavel On Mon, Jun 21, 2010 at 11:54 PM, P Kishor <punk.k...@gmail.com> wrote: > On Mon, Jun 21, 2010 at 10:44 PM, Sam Carleton > <scarle...@miltonstreet.com> wrote: >> I have asked this Q a number of times over the last year and NEVER gotten >> ANYONE to even comment on it. I am wondering why: >> >> Am I opening the DB too much? > > what is too much? I mean, the computer is not going to get tired. But, > are you experiencing speed bottlenecks? > >> >> My usage of SQLite is in an Apache module that opens the DB each time it >> needs info from the DB: For authentication it is open/closed, for the >> initialization of the request the db is open/closed, for the processing of >> the request, the db is opened and closed. > > If all of the above is happening within one logical transaction (and, > I don't mean, a db transaction -- since you mentioned Apache, I mean, > a "job," a "click" from the user's point of view), you certainly can > and should open a single db connection, do everything you want to do, > close the db, and then return the result to the user. At least, that > is how I do it. > > In fact, once the Apache process ends, the db connection should close > automatically, although it doesn't hurt to close it explicitly. > > > > >> >> Is this OK, or should I open it once for the whole request and close it when >> the whole request is finished? >> >> Sam >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> > > > > -- > Puneet Kishor http://www.punkish.org > Carbon Model http://carbonmodel.org > Charter Member, Open Source Geospatial Foundation http://www.osgeo.org > Science Commons Fellow, http://sciencecommons.org/about/whoweare/kishor > Nelson Institute, UW-Madison http://www.nelson.wisc.edu > ----------------------------------------------------------------------- > Assertions are politics; backing up assertions with evidence is science > ======================================================================= > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
