char or int to table ID (no replies)
(MySQL.com) what will be better for the id index on a table holding temporary data (can long hours to 7 days)
id: int(10) [AUTO_INCREMENT] PRIMARY
OR
id: char(32) [md5] PRIMARY
Note: table got many inserts per minute, data is only acessed when users wan
Update update feed set failed_fetches=0, fetched=current_timestamp() where feed_id = 1268 failed: 1142 [UPDATE command denied to user '334187_hdlns_ms5'@'10.187.248.89' for table 'feed'] in [update feed set failed_fetches=0, fetched=current_timestamp() where feed_id = 1268]
updated 1268 (MySQL User Forums), inserted 30, updated 0, at 2012-06-02 00:10:27
