Re: Locking threads
- From: Jim <jimyt@xxxxxxxxx>
- Date: Mon, 16 Jul 2007 00:25:51 -0700
I'm developing a CMS and I'd like to be able cache the site "tree" in
a multi-dimensional array in shared memory (far too many sql calls
otherwise). When someone adds an item in the tree I need to be able to
read in the array from shared memory, add the new item, then write it
back to shared memory.....all in one atomic action.
I've done plenty of research and short of using something like
eaccelerator or mmcache I'm stuck with PHP semaphores which even then
don't appear to be thread safe, only process safe (correct me if I'm
wrong) - and then I'm restricted to *nix systems.
Is there any way to create a method of doing the above which will work
on *nix and Windows, whether it's multi-threaded or single-threaded?
Use a database. There are dozens around which use databases; if
implemented properly they can be quite efficient.
If I could think of a way of doing it efficiently then I'd stick with
db only, but I can't see how. For example, I have a table which
represents the structure of the site, so to put it simply each record
has an id and a parent id. To build say a left hand nav I may need to
call 3 or 4 sql statements to get all the data I need which I'd like
to avoid doing if possible.
- Prev by Date: Next Generation Information Map Site
- Next by Date: Re: Locking threads
- Previous by thread: Re: Locking threads
- Next by thread: Re: Locking threads