[imp] Re: [horde] Who is online?

[Jan Schneider]

Zitat von Lord Apollyon <implist at paypc.com>:

> > We found that by removing things like "who's online"
> > tracking information out of programs like phpnuke we get a good amount
> of
> > CPU back under normal usages (300k hit's/day).
>
> Let me guess, he's using mySQL.  mySQL is the Open Source Posterchild of
> the
> Day, but it's not a very fast database when you start to really lean on
> it.
>  One area of "lean" it's not good at handling is extensive UPDATE/INSERTs
> on
> read-active tables.  Notice how many language constructs they've created
> to
> try to minimise the inevitable - UPDATE DELAYED, PRIORITY, etc.

But of course this (being one of the fastest out there) RDBMS has support
for in-memory HEAP tables that are the ideal table type for session
handlers and live logging/statistics.

Jan.

--
http://www.horde.org - The Horde Project
http://www.ammma.de - discover your knowledge
http://www.tip4all.de - Deine private Tippgemeinschaft