Andrew Hill [EMAIL PROTECTED] wrote:
Perhaps it would be better to insert the timestamp, rather than letting
MySQL set it.
Sure. This gives consistency in your situation.
Or, is there perhaps a way to let MySQL select which table
to perform the insert into, based on the time?
No.
-Original Message-
From: William H. Bowers [mailto:[EMAIL PROTECTED]
Sent: 22 July 2004 03:55
To: [EMAIL PROTECTED]
Subject: re: Splitting data across tables
If indexing seems to be the cause of the slowdown, it may be
faster to drop the indexes, add the new data
In article [EMAIL PROTECTED],
Andrew Hill [EMAIL PROTECTED] writes:
Hi,
Okay, cool. A couple of things:
1) We *think* that our bottleneck is RAM and the calculation of indexes
when inserting into the table (about 500 million rows). There's
certainly plenty of CPU and disk I/O left in the
Hi all,
We have quite a large table, and are considering splitting the data into
daily tables - something like tblname_20040721, tblname_20040722, etc.
Hopefully, this will allow us to more easily delete old data through
dropping the old tables, instead of using DELETE. (At present, we're
A. McCaskey
-Original Message-
From: Andrew Hill [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 21, 2004 8:00 AM
To: [EMAIL PROTECTED]
Subject: Splitting data across tables
Hi all,
We have quite a large table, and are considering splitting the data into
daily tables - something like
and may be unlawful.
--
-Original Message-
From: John McCaskey [mailto:[EMAIL PROTECTED]
Sent: 21 July 2004 16:24
To: Andrew Hill; [EMAIL PROTECTED]
Subject: RE: Splitting data across tables
I've had no problems
PROTECTED]
Sent: Wednesday, July 21, 2004 8:46 AM
To: [EMAIL PROTECTED]
Subject: RE: Splitting data across tables
Hi,
Okay, cool. A couple of things:
1) We *think* that our bottleneck is RAM and the calculation of indexes
when inserting into the table (about 500 million rows). There's
certainly
/bowers
-Original Message-
From: John McCaskey [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 21, 2004 11:50
To: Andrew Hill; [EMAIL PROTECTED]
Subject: RE: Splitting data across tables
As far as I know there is no way to make mysql choose the table to
insert to dynamically. However