Called KEY in mysql

1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User

Welcome to IWETHEY!

Post #160,761 by drewk 6/21/04 10:41:58 AM Reply	Called KEY in mysql PRIMARY KEY (`idnum`),\n KEY `time_stamp` (`time_stamp`),\n KEY `reference_number` (`reference_number`) === Implicitly condoning stupidity since 2001.
Post #160,775 by admin 6/21/04 11:00:21 AM Reply	Oh, heh. Never mind. Seems silly for them to invent their own syntax... Regards, -scott anderson "Welcome to Rivendell, Mr. Anderson..."

Why would a database insert take >40 seconds? - (drewk) - (7) - June 19, 2004, 03:14:14 AM EDT

No idea, just a wild guess - (Meerkat) - (1) - June 19, 2004, 11:44:39 AM EDT

Full table scan is faster - (drewk) - June 19, 2004, 01:59:38 PM EDT

Are there indexes on other columns? - (ben_tilly) - (4) - June 19, 2004, 03:39:54 PM EDT

Here's the table - (drewk) - (3) - June 21, 2004, 10:10:54 AM EDT

What are the indexes though? -NT - (admin) - (2) - June 21, 2004, 10:20:35 AM EDT

Called KEY in mysql - (drewk) - (1) - June 21, 2004, 10:41:58 AM EDT

Oh, heh. Never mind. - (admin) - June 21, 2004, 11:00:21 AM EDT

Di people dem a beg di super DJ fi more. Because dem love di way wi play di hardcore.
46 ms