To be honest, this sounds like more of a filesystem thing, given that you
only ever need to select the full set of an individual user. Just build up
an FS structure with one file per user.
On Wed, Jul 1, 2009 at 7:57 PM, Marcus Bointon mar...@synchromedia.co.ukwrote:
I need to log fairly large
On 3 Jul 2009, at 09:42, Johan De Meersman wrote:
To be honest, this sounds like more of a filesystem thing, given
that you only ever need to select the full set of an individual
user. Just build up an FS structure with one file per user.
You really think so? Even though I'll need to
Marcus Bointon wrote:
For the most part this is write-only and is only ever read very rarely,
but when I do, it will be to retrieve the details of a single user, and
all I need is the whole history, not individual events.
For your stated requirements the filesystem is probably most
On Fri, Jul 3, 2009 at 12:09 PM, Marcus Bointon
mar...@synchromedia.co.ukwrote:
On 3 Jul 2009, at 09:42, Johan De Meersman wrote:
To be honest, this sounds like more of a filesystem thing, given that you
only ever need to select the full set of an individual user. Just build up
an FS
nigel wood wrote:
Here's a rough table stucture. The indexes in events tables would be
TargetId. But problably TargetId+EventDate probably eventId+event date
as you found more uses/added paging.
Well that didn't format very well :-( The tables structures are:
User/Actor
===
TargetId
Nigel/Marcus/Johann
mghopefully quick answer
nigel wood wrote:
Here's a rough table stucture. The indexes in events tables would be
TargetId.
mgthere would be need to be a 1:1 correspondence between
mgTargetId index and Username..all of your other tables would need to know
mgthe
Dear all,
I am running mysql server sharing with apache web server in a box of freebsd
6.4. Hardware spec is roughly as bellow:
CPU: Xeon 3.06GHz x 2
Mem: 4GB
The version of Mysql is 5.1.17_beta, a pre-complied binary package for FreeBSD.
Recently the apache request raises quickly, sometime