On Fri, 23 Feb 2001, Brian Baquiran wrote:
..
> I'm not familiar w/ MySQL or your datamodel but if your active_sessions has
> a timestamp column then you can delete from active_sessions where the time
> difference between now and the timestamp is greater than some value.
>
> Hmm. This is pretty obvious so you've probably already thought of it and for
> some reason or another it won't work with your setup, otherwise you wouldn't
> have posted your problem.
the problem is that mysql is a dumbass "SQL interface to the
filesystem." try doing your delete while somebody else is inserting.. and
your delete will block. when your delete FINALLY gets access, it will
block everything else... which is BAD if you do a lot of deletes.
moral of the story: mysql is good for read-only queries or for people just
dipping their toes into the waters of SQL databases. but don't use it for
real work. (sourceforge does.. and when they trial-ported to postgresql,
they got a 100X speed increase)
---------------------------------------------------------------------
Orlando Andico <[EMAIL PROTECTED]> POTS Phone: +63 (2) 937-2293
Mosaic Communications, Inc. GSM Mobile: +63 (917) 531-5893
I'm not suffering from insanity -- I'm enjoying every minute of it!!
_
Philippine Linux Users Group. Web site and archives at http://plug.linux.org.ph
To leave: send "unsubscribe" in the body to [EMAIL PROTECTED]
