>Michel, sorry if already answered- but how do you use the hit table? Is it for manual trawling to track particular activity or ???
We use it at large. We provide in the same list filtering over 30 days by various search criteria to get the hits to the Web site and the hits to the Web Service. We can filter by individual field or a combination, the same as you can do here. There is also a robot which extracts some of that data for a customized client report. Then, we need to recycle it over 30 days as we do not have any use to keep it longer than that.
We do not have as much hits as you do. We are ranging at closing one million hits per day. We will close 1.5 by the end of the year. This recycle process is to be done carefully. I believe by deleting in batch of 2000 records, such as recommended at a few sites will be the best optimized approach. So far, on our UAT environment, this is faster.
Yes, you are right. If you break the table, you will not be able to achieve what you mentioned. This is why I need to keep it all in the same table.