[AndrewD]

Originally Posted by Ophelia

Also, it appears that when you tidy up the table > delete, you have to run this twice in order for it to visually show that it's deleted something.

I've dumped ours down to 30 days, and leads "There are currently 59613 records in the LDM Download 'Hits' table." Folks seriously need to stop downloading stuff!

The main routine overhead is when you enable the 'hit parade' on the LDM home page. On my test PC with an LDM database with 33,000 hits, the sql statement required to select the hit parade entries requires 0.12 seconds CPU, an overhead that is required each time the page is displayed.

I've already taken steps to improve the efficiency of this step, and at some stage, I may make it much better (by keeping a 'day table' of hits).

Concerning the 'delete hits' page, it works correctly the first time you select it, but there's no page refresh, I realise.