RE: Endless primary key build

2004-06-07 Thread Jan Goyvaerts \(jgoyvaer\)
: Endless primary key build On 24 May 2004, at 10:49 am, Jan Goyvaerts ((jgoyvaer)) wrote: My only conclusion is that getting the data first from another database does something to mySQL... The other difference is the data. Your test data was probably evenly distributed, or normally distributed

Endless primary key build

2004-05-24 Thread Jan Goyvaerts \(jgoyvaer\)
Hello people, I'm having a strange behavior when rebuilding and querying a 58million row table. Probably because I'm new to mysql. I'm using it through java btw. My table has three columns: 2 mediumint and 1 smallint. The first two columns are the primary key. My first test was to write