I'm not sure I understand exactly what you mean, but I think you just need to
keep a timestamp associated with each row as it is inserted, put an index on
it, then you can select new data just by using the appropriate time range.
Also, if you're parsing files into tab delimited format, you
On Nov 8, 2010, at 1:23 PM, Gavin Towey wrote:
I'm not sure I understand exactly what you mean, but I think you just need to
keep a timestamp associated with each row as it is inserted, put an index on
it, then you can select new data just by using the appropriate time range.
But won't
.
-Original Message-
From: Hal Vaughan [mailto:h...@halblog.com]
Sent: Monday, November 08, 2010 1:39 PM
To: mysql@lists.mysql.com
Subject: Re: Running Queries When INSERTing Data?
On Nov 8, 2010, at 1:23 PM, Gavin Towey wrote:
I'm not sure I understand exactly what you mean, but I think you just
, and experiment
with optimizations.
-Original Message-
From: Hal Vaughan [mailto:h...@halblog.com]
Sent: Monday, November 08, 2010 10:39 AM
To: mysql@lists.mysql.com
Subject: Re: Running Queries When INSERTing Data?
On Nov 8, 2010, at 1:23 PM, Gavin Towey wrote:
I'm not sure I understand