MySQL Forums

Hello at all,

I tried to store pictures in a database. But with increasing recordcount performance will get very poor. (up to serveral seconds for one select)

Witch parameters changes could help out of this problem?

Database is on local computer as well as on Networkserver (but mostly local).

Here the structure of the table:
CREATE TABLE `images` (
`ImageGUID` char(38) NOT NULL default '',
`ImageExamDataID` char(38) NOT NULL default '',
`ImageIndex` tinyint(3) unsigned NOT NULL default '0',
`ImageType` tinyint(4) default NULL,
`ImageDate` datetime default NULL,
`ImageData` mediumblob,
`ImageDeviceID` char(38) default NULL,
`ImageWidth` smallint(3) unsigned default NULL,
`ImageHeight` smallint(3) unsigned default NULL,
`ImageColorDepth` tinyint(3) unsigned default NULL,
PRIMARY KEY (`ImageGUID`,`ImageExamDataID`,`ImageIndex`),
UNIQUE KEY `ImageGUID` (`ImageGUID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Stores the Images'

Or may be someone has other ideas to increase performance.

Thanks for help

Juergen



Edited 1 time(s). Last edit at 11/12/2008 12:28PM by Juergen Reber.