Here's the table

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

Welcome to IWETHEY!

Post #160,749 by drewk 6/21/04 10:10:54 AM Reply	Here's the table CREATE TABLE `appraisal_files` (\n `idnum` bigint(20) unsigned NOT NULL auto_increment,\n `time_stamp` timestamp(14) NOT NULL,\n `reference_number` bigint(20) unsigned NOT NULL default '0',\n `source_filename` varchar(128) NOT NULL default '',\n `source_extension` varchar(5) NOT NULL default 'PDF',\n `source_data` longblob NOT NULL,\n PRIMARY KEY (`idnum`),\n KEY `time_stamp` (`time_stamp`),\n KEY `reference_number` (`reference_number`)\n) TYPE=MyISAM This already is the separate table for the blobs. === Implicitly condoning stupidity since 2001.
Post #160,750 by admin 6/21/04 10:20:35 AM Reply	What are the indexes though? Regards, -scott anderson "Welcome to Rivendell, Mr. Anderson..."
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

We still think digital watches are a pretty neat idea.
56 ms