[PHP] mysql sessions vs flat file?

2004-12-17 Thread Jason Morehouse
Hello all, Has anyone had an experience with storing sessions in mysql (or sqlite)? If so, what if any are the performance benefits? Obviously, there would have to be an extra db query per page... but would that be faster then opening a text file? Also, I was trying to post to the php news

Re: [PHP] mysql sessions vs flat file?

2004-12-17 Thread Raditha Dissanayake
Jason Morehouse wrote: Hello all, Has anyone had an experience with storing sessions in mysql (or sqlite)? If so, what if any are the performance benefits? Obviously, there would have to be an extra db query per page... but would that be faster then opening a text file? Speed depends on

Re: [PHP] mysql sessions vs flat file?

2004-12-17 Thread Robert Cummings
On Fri, 2004-12-17 at 11:34, Richard Lynch wrote: Granted, this assumes you've got a good clean working SQL-based session setup in the first place, which is several days, perhaps even weeks of work for the beginner, before they really understand all the bits and pieces and ins and outs of the

Re: [PHP] mysql sessions vs flat file?

2004-12-17 Thread Richard Lynch
Jason Morehouse wrote: Has anyone had an experience with storing sessions in mysql (or sqlite)? Yes, in MySQL. If so, what if any are the performance benefits? This depends on *SO* many factors... Is your MySQL database pretty small? Is your site heavy traffic? Are most of your sessions

Re: [PHP] mysql sessions vs flat file?

2004-12-17 Thread Richard Lynch
Robert Cummings wrote: On Fri, 2004-12-17 at 11:34, Richard Lynch wrote: Granted, this assumes you've got a good clean working SQL-based session setup in the first place, which is several days, perhaps even weeks of work for the beginner, before they really understand all the bits and

Re: [PHP] mysql sessions vs flat file?

2004-12-17 Thread Greg Donald
On Fri, 17 Dec 2004 09:57:56 -0800 (PST), Richard Lynch [EMAIL PROTECTED] wrote: Yeah, a beginner trying to write an OOP MySQL session based system would take MONTHS, and still get it all wrong with nasty snarled code. Months? Come on.. it's just six functions and a call to