RE: Endless primary key build

2004-06-07 Thread Jan Goyvaerts \(jgoyvaer\)
Jan Goyvaerts (jgoyvaer) Subject: Re: 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

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 58mill