| Jorey Bump 2005-09-23, 7:46 am |
| Nicolas Lehuen wrote:
> That being said, why SQLite ? Because it's simple to install and use (no
> administration required). You just give it a file name and you're ready
> to roll. Plus, I really wanted to experiment with SQLite  .
>
> I must confess that the current implementation seems 30% slower than
> FileSession, but we are not cluttering the filesystem (due to FS
> clusters, FileSession files all use a lot of disk space) and cleaning up
> old sessions is very fast (I used a DELETE FROM sessions WHERE ... just
> like Jim described), contrary to FileSession, so there is a tradeoff.
Doesn't SQLite suffer from similar locking issues you'd encounter with a
pickle? Wouldn't the lack of concurrent write access cause problems on a
busy server?
|