Hi,
Speaking only as a non-professional, I still try to answer. I don't
want to comment on the benefits of shared cache mode now, but only on
the question if it can be enabled in Apache. And I believe it can. As
you say Apache pre-forks different processes, but within each process
it pre-establishes different threads and I think the default is in
the order of 100. So practically you will only use a single process
and hence can easily enable shared-cache mode. This assumes that your
application is loaded into Apache, and does not run via cgi.
Regards, Edzard Pasma
Op 24-jan-2008, om 16:48 heeft Brandon, Nicholas (UK) het volgende
geschreven:
Hi all,
Could the 'Shared Cache' option in SQLite theoretically improve the
performance of the db if used by multiple processes? The
application in
particular is Apache using pre-fork processes accessing the same db.
The info at http://www.sqlite.org/sharedcache.html seems to
indicate it
could benefit threads only.
I believe it would not but would like confirmation from someone else.
Thanks
Nick
********************************************************************
This email and any attachments are confidential to the intended
recipient and may also be privileged. If you are not the intended
recipient please delete it from your system and notify the sender.
You should not copy it or use it for any purpose nor disclose or
distribute its contents to any other person.
********************************************************************
----------------------------------------------------------------------
-------
To unsubscribe, send email to [EMAIL PROTECTED]
----------------------------------------------------------------------
-------
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
