Maximum number of rows

2002-09-02 Thread Lukas Knecht
) We're afraid there is hard, implementation imposed limit of unsigned int (2^32) on the number of rows. Before trying to verify this by loading 4.3 billion records into a table, I thought it would be worth asking... Thanks, Lukas Knecht

Re: Maximum number of rows

2002-09-02 Thread Lukas Knecht
Shashank Tripathi wrote: Hi Lucas, | Does anyone know what the maximum number of rows a | MyISAM table can store is? We currently have a table | We're afraid there is hard, implementation imposed limit | of unsigned int (2^32) on the number of rows. Before trying My

Again: ORDER BY key_part1,key_part2 does not use index

2001-06-11 Thread Lukas Knecht
the ORDER BY part: SELECT * FROM foo ORDER BY key_part1,key_part2,key_part3; Isn't this information wrong or at least incomplete? Can anyone shed some light on this? Thanks. Lukas Knecht infox Neptunstr. 35 CH-8032 Zürich