Author Topic: Remove tracked hits? (Read 4365 times)

BGSWebDesign · « **on:** December 06, 2005, 07:16:50 am »

Hi,

Does anyone know how to remove the Tracked Hits? I can 'reset', but that does NOT remove the tracked hits that are saved in the database?

It looks like you have to manually removed the Tracked Hits, my track database is getting HUGE!

I just entered the following SQL code and ran it:

Code: [Select]

DELETE FROM `lm_hits` WHERE 1

This removed over 9,000 hits that were there... now, what is the optimization SQL code I should run to optimize it?

DW - how about adding an option at the bottom of the Tracking page to REMOVE old Tracked Hits, or on the Configuration page?

DW · « **Reply #1 on:** December 06, 2005, 07:51:04 am »

This small request will almost certainly make it into one of the next updates. Tracked hits and links need a lot of work. I'll be making big improvements soon.

Regards

BGSWebDesign · « **Reply #2 on:** March 25, 2006, 08:45:25 am »

Hi DW,

One question on this:

Quote

what is the optimization SQL code I should run to optimize it?

It seems even though I run this command and delete the hits, the size of the database does NOT go down, is that right? OOps, I guess so, I see the size of my hits table is only 317 KB, and I have over 10,000 hits, so it probably doesn't reduce it as much as removing the bounced users

DW · « **Reply #3 on:** March 28, 2006, 11:59:09 am »

One thing to note is there is a certain amount of overhead left in the database after deleting rows - you can see this in PhpMyAdmin. This overhead should be cleaned up when "optimize table <table>" is executed either manually or at dailymail.

As of a version released some time ago there should be some "Maintenance Options" on the ListMail Configuration page. One of the options is the number of tracked hits to keep in the database - default is 5000. Your tracked hits in excess of this setting should be automatically removed by dailymail.

Regards