Re: Re[2]: [PHP-DEV] Removing SQLite sessions from the defaultdistribution

2003-07-01 Thread John Coggeshall
I have been staying out of this discussion because everyone has really been making my points for me. I think SQLite sessions are a good alternative to what we have now in some situations, and I'd like to see them in PHP5 for the same reasons as Marcus Wez and Sascha. This isn't the huge disaster y

Re: Re[2]: [PHP-DEV] Removing SQLite sessions from the defaultdistribution

2003-07-01 Thread Sascha Schumann
On Wed, 1 Jul 2003, Sterling Hughes wrote: > Wez explained to me a real world usage (over IRC). Could not that have happened a couple of hours earlier? :) - Sascha -- PHP Internals - PHP Runtime Development Mailing List To unsubscribe, visit: http://www.php.net/unsub.php

Re: Re[2]: [PHP-DEV] Removing SQLite sessions from the defaultdistribution

2003-07-01 Thread Sterling Hughes
Wez explained to me a real world usage (over IRC). I still think its a terrible idea, but I'll drop it . -Sterling On Tue, 2003-07-01 at 20:17, Sascha Schumann wrote: > Tallied votes so far. > > Yay: Sterling > Nay: John, Marcus, Wez, Sascha > Abstain: Jani > > - Sascha --

Re: Re[2]: [PHP-DEV] Removing SQLite sessions from the defaultdistribution

2003-07-01 Thread Sterling Hughes
On Tue, 2003-07-01 at 20:17, Sascha Schumann wrote: > Tallied votes so far. > > Yay: Sterling > Nay: John, Marcus, Wez, Sascha > Abstain: Jani - John He hasn't given his opinion in this thread. -Sterling > > - Sascha -- "Programming today is a race between software enginee

Re: [PHP-DEV] Removing SQLite sessions from the defaultdistribution

2003-07-01 Thread Sterling Hughes
On Tue, 2003-07-01 at 19:51, Wez Furlong wrote: > What is the point of publishing a benchmark if you are not comparing an SQL > data store with an SQL data store? Speaking of bullshit comparisons :) One is a client/server architecture, the other is a direct disk access architecture. Using an RDB

Re: [PHP-DEV] Removing SQLite sessions from the defaultdistribution

2003-07-01 Thread Wez Furlong
- Original Message - From: "Sterling Hughes" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, July 01, 2003 9:51 PM Subject: Re: [PHP-DEV] Removing SQLite sessions from the defaultdistribution > > 4) Marginally more

Re: [PHP-DEV] Removing SQLite sessions from the defaultdistribution

2003-07-01 Thread Wez Furlong
- Original Message - From: "Sterling Hughes" <[EMAIL PROTECTED]> To: "George Schlossnagle" <[EMAIL PROTECTED]> Cc: "Wez Furlong" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; "Sascha Schumann" <[EMAIL PROTECTED]> Sent:

Re: [PHP-DEV] Removing SQLite sessions from the defaultdistribution

2003-07-01 Thread Wez Furlong
What is the point of publishing a benchmark if you are not comparing an SQL data store with an SQL data store? > I will commit my fixes, if the decision is to bundle sqlite. Or someone > is interested in trying it out in the interim. Commit it. > Also note, this would mean that all > shared hos

Re: [PHP-DEV] Removing SQLite sessions from the defaultdistribution

2003-07-01 Thread Sterling Hughes
Not to reply to myself, however, one thing I have not heard this time is a real world usage of this functionality. One case where "you" (ie, someone on the list) would extract a benefit from using the SQLite backend. Give me a problem that using SQLite as a *generic* session backend will solve yo

Re: [PHP-DEV] Removing SQLite sessions from the defaultdistribution

2003-07-01 Thread Sterling Hughes
On Tue, 2003-07-01 at 16:56, Ilia Alshanetsky wrote: > >From a performance standpoint you are correct, SQLite looses to files. The > actually performance seems to be quite drastic (very surprising to me). That > said, keep in mind that for most applications even 150 requests/second is an > unatt

Re: [PHP-DEV] Removing SQLite sessions from the defaultdistribution

2003-07-01 Thread Jason Greene
On Tue, 2003-07-01 at 15:56, Ilia Alshanetsky wrote: > From a performance standpoint you are correct, SQLite looses to files. The > actually performance seems to be quite drastic (very surprising to me). That > said, keep in mind that for most applications even 150 requests/second is an > unatta

Re: [PHP-DEV] Removing SQLite sessions from the defaultdistribution

2003-07-01 Thread Jason Greene
> Is not a hard cross to bear, and considering that sqlite enabled > sessions should be avoided in the first place, I think its a bad idea to > include them by default. > > -Sterling + 1 One thing I would like to point out here, is that a session backend is transparent to the user. As long as

Re: [PHP-DEV] Removing SQLite sessions from the defaultdistribution

2003-07-01 Thread Sterling Hughes
> My point being that 1/3 slowdown seems to be about worst case, given > the construction of your benchmark. The test was both designed to > exploit lock contention (which does increase in overhead non-linearly > under usage due to the queueing issues involved) and to measure only > the overh

Re: [PHP-DEV] Removing SQLite sessions from the defaultdistribution

2003-07-01 Thread Sterling Hughes
On Tue, 2003-07-01 at 16:33, George Schlossnagle wrote: > On Tuesday, July 1, 2003, at 04:00 PM, Sterling Hughes wrote: > > On Tue, 2003-07-01 at 16:15, George Schlossnagle wrote: > >> On Tuesday, July 1, 2003, at 03:28 PM, Sterling Hughes wrote: > >> > >> > >> This is no different than a typical

Re: [PHP-DEV] Removing SQLite sessions from the defaultdistribution

2003-07-01 Thread Sterling Hughes
On Tue, 2003-07-01 at 16:08, Elfyn McBratney wrote: > On Tue, 1 Jul 2003, Sebastian Bergmann wrote: > > > Sterling Hughes wrote: > > > It offers not one practical advantage. > > > > I though the same, the SQLite euphoria should not be taken too far. > > > > +1 for removing the SQLite Session S

Re: [PHP-DEV] Removing SQLite sessions from the defaultdistribution

2003-07-01 Thread Sterling Hughes
On Tue, 2003-07-01 at 16:20, George Schlossnagle wrote: > On Tuesday, July 1, 2003, at 03:49 PM, Sterling Hughes wrote: > > You can't look at raw performance on a simple script in terms of req/s, > > but rather percentages. Most scripts are complex, and will have plenty > > of other logic in them

Re: [PHP-DEV] Removing SQLite sessions from the defaultdistribution

2003-07-01 Thread Sterling Hughes
On Tue, 2003-07-01 at 16:15, George Schlossnagle wrote: > On Tuesday, July 1, 2003, at 03:28 PM, Sterling Hughes wrote: > > > Hi, > > > > Recently sqlite sessions have been added by default. I think this is a > > bad idea to have as a default handler. SQLite is not designed for a > > write inte

Re: [PHP-DEV] Removing SQLite sessions from the defaultdistribution

2003-07-01 Thread Sterling Hughes
What advantage does it bring? It is *only* a disadvantage. It can only hurt users, it can't help them. I would be for it if someone gave me a practical usage, no one has. Its not the right tool for the job. If you want to shoot yourself in the foot, PEAR is the place to do that. -Sterling On

Re: [PHP-DEV] Removing SQLite sessions from the defaultdistribution

2003-07-01 Thread Sterling Hughes
On Tue, 2003-07-01 at 15:57, Wez Furlong wrote: > Sterling, you still seem to be afraid to benchmark sqlite vs mysql or > postgresql sessions. I'm not afraid. Its like compare apples with oranges. MySQL and PostgreSQL are database servers, they give you wins in terms of reliability, power and da