On Feb 11, 2004, at 1:47 AM, nyem wrote:
It works fine on small number of rows, but when the table reaches 400
rows the time it took to execute the query was 16 sec. And my cpu shot
up to 100% whenever I populate 1000 rows. What have I done wrong here?
Did you try creating an index on the
Hello,
I have this table which stores an ever changing price of items.
CREATE TABLE shop (
article INT(4) UNSIGNED ZEROFILL NOT NULL default '',
date DATE NOT NULL default '-00-00',
price DOUBLE(16,2) NOT NULL default '0.00',
KEY article (article,date)
);
And I
Got any indexes?
--ja
On Wed, 11 Feb 2004, nyem wrote:
Hello,
I have this table which stores an ever changing price of items.
CREATE TABLE shop (
articleINT(4) UNSIGNED ZEROFILL NOT NULL default '',
date DATE NOT NULL default '-00-00',
price