truncate tables #19
Description
The query that CakePHP builds to truncate the tables is not that good because it is using IN($ALL_IDS)
DELETE `Command` FROM `naemon`.`naemon_commands` AS `Command` WHERE `Command`.`command_id` IN (1188, 1189, 1190, 1191, 1192, 1193, 1194, 1195, 1196, 1197, 1198, 1199, 1200, 1201, 1202, 1203, 1204, 1205, 1206, 1207, 1208, 1209, 1210, 1211, 1212, 1213, 1214, 1215, 1216, 1217, 1218, 1219)Solution: Replace with TRUNCATE TABLE ...