block size for optimal index usage. I can't seem to find
any information about changing this value.
D. Walton
sql
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysq
I have a table with 3 fields, 'id', 'date', and 'value'. I've created a
unique index on 'id' and 'date' in order to lookup 'value' quickly. I
would like to be able to add 'value' to the index so that the data files
does not have to be referenced and will allow faster lookups and groupings
by
At 05:18 PM 11/5/2002 -0800, you wrote:
On Tue, Nov 05, 2002 at 07:14:25PM -0600, D. Walton wrote:
>
> I have a table with 3 fields, 'id', 'date', and 'value'. I've created a
> unique index on 'id' and 'date' in order to lookup &
At 10:32 PM 11/5/2002 -0600, you wrote:
At 20:39 -0600 11/5/02, D. Walton wrote:
At 05:18 PM 11/5/2002 -0800, you wrote:
On Tue, Nov 05, 2002 at 07:14:25PM -0600, D. Walton wrote:
I have a table with 3 fields, 'id', 'date', and 'value'. I've created a
At 01:05 AM 11/6/2002 -0600, you wrote:
Paul, the point was to have 'value' be part of the primary key for pure
lookup speed (data file would not need be referenced), but not to have it
effect the uniqueness of the 'id'/'date' key pair so that I could do an
'insert ignore' into the table with a
