Hello.
> But now this takes forever...
May be you have some locks or your system is heavy-loaded. Use 4.1.9 instead of
4.1.7.
"Kevin A. Burton" <[EMAIL PROTECTED]> wrote:
> Under 4.0.18 we were loading about 800M of data into a memory table to
> get better performance from some of our
Dathan Pattishall wrote:
Hmm that's a range, that should do a table scan in 4.0.18,
Yes... I believe it did but since its a memory table it went by really
quick.
since a
memory table type is just a hash table. In 4.1 I believe it supports
ranges since the table is more of a myISAM type.
Yes.
Hmm that's a range, that should do a table scan in 4.0.18, since a
memory table type is just a hash table. In 4.1 I believe it supports
ranges since the table is more of a myISAM type.
Is there an index on TIMESTAMP?
Does the range cover more then 30% of the table?
> -Original Message-
