We're running price tapestry for quite some time on InnoDB now and pretty satisfied with it. However as the table grows during the import process the INSERTs become very slow, I guess also because the table uses quite some indexes.
Do you have any suggestions regarding improvements on an InnoDB table for the cron.php import process? I guess transactions would do some good but I'm not quite sure where exactly to implement it.
Please let me know if you have any other suggestions or advice on how to implement transactions :)
Thanks in advance!