Just thought I would explain my stupidity!
One of my tables which I'd forgotten about was 100k entries but I'd dropped
the primary key off earlier. Adding the primary key back again made the two
machines the same speed immediately.
Its amazing what indexes can do!
David
>
>Hi, I hope that
Hi, I hope that someone can help me on this matter.
I have a C program which uses MySQL. This program does many many (>100,000)
SELECT, INSERT, UPDATE, DELETE on single HEAP tables. The machine I developed
it on was a P3 800 256MB Linux machine running MySQL 3.22.32 (standard version
of MyS