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 > unattainable limit anyway. For example smarty templating system demo peaks at > about 2.5 requests/second and phpMyAdmin front page does a whooping 10 > requests/second and a list goes on an on. > So what do we do, I still think having sqlite session handler is a good idea > especially since all the tools necessary for it's operation are bundled by > default. Not so with MySQL and PostgreSQL which require working server, > password, logins etc... Which is why I believe we should still keep in the > main trunk rather then move to PECL. > As far as sqlite session handling benefits go, there are several: > 1) Single file vs many file (rm -f will fail if there are too many files in a > particular directory), which makes for easier maintenance.
If too many files in a dir became a problem, directory hashing could easily be implemented into the file based handler. > 2) Much easier to find & manipulate sessions outside of normal sessions > framework. This I can maybe see, however I am not sure what the practical reasons are to dig through a session database, besides perhaps deleting old sessions, and that is something easily done with file sessions > 3) Extremely easy to move sessions from one server to another I really can't see why you would want to do this. > 4) Marginally more secure then plain files This reminds me of an argument I had with an unnamed firewall vendor that storing an entire site security policy all on one box was ok because its compiled. There really is no security difference here. > P.S. On the benchmark note it should be mentioned that the sqlite session > handler does appear to use indexes, which could explain why session lookups > are so slow. But it may average out, since that would make inserts faster. I think you will still see a significant performance difference between file and sqlite -Jason -- Jason Greene <[EMAIL PROTECTED]> <[EMAIL PROTECTED]> -- PHP Internals - PHP Runtime Development Mailing List To unsubscribe, visit: http://www.php.net/unsub.php