… the disk were stored in the database: CREATE TABLE `imagecache` ( `url` varchar(255) character set latin1 NOT NULL default ”, `thumb_width… NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, PRIMARY KEY (`url`,`thumb_width`,`thumb_height`) ) ENGINE=InnoDB; Why did I use… in this case as if I would decide to use md5(url) or something similar as a key – it is often many…

Hi Peter, I like the MD5 of the URL suggestion. Would you not get the same clustering/insert benefit … that as the PK? Hash of the URL domain + Hash of the URL path (or full URL) That way you would have a…