May 24, 2012

Post: Long PRIMARY KEY for Innodb tables

… had the task to store meta data about thumbnails for images retrieved from various web sites in the Internet. Thumbnails themselves… I would decide to use md5(url) or something similar as a key – it is often many images from one domain/album… plus we might want to get all thumbnails for given image url effectively. In general I use this example as illustration…