to get round the caching issue with the site having to manually delete db entries, simply run a cron job on all xml files saved every 24 hours that checks whether the file is older than 24 hours and if it is, the file is deleted. this would remove the need for the app to delete db entries.
this development will have to happen once the caching mechanism has been updated to use xml files rather than saving flat xml in the db.
to get round the caching issue with the site having to manually delete db entries, simply run a cron job on all xml files saved every 24 hours that checks whether the file is older than 24 hours and if it is, the file is deleted. this would remove the need for the app to delete db entries. this development will have to happen once the caching mechanism has been updated to use xml files rather than saving flat xml in the db.