Hey,

im putting together ideas on what i can have in a maintenance script im planning to add to a CMS im building.

and im not quite sure what i could have it do which would be usful?

Ideas on a post card... or just a response here will do

Dan.

Optimizing a database.
Preprocessing data for summary reports.
Deleting old caches.

Just a few suggestions.

what sort of thing could i do to optimise a database?

I will probally add a thing, to check all files/folders etc are writeable and all that as a thing.

Thanks,
Dan