Posted by c-c-m on March 8, 2009 at 9:08pm
Jump to:
| Project: | Advertisement |
| Version: | 5.x-1.7 |
| Component: | ad module |
| Category: | feature request |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | postponed |
Issue Summary
Hello,
I have discovered that one of the largest tables of my database is ad_statistics, with 25MB. I wanted to flush its content in order to free some space, but I want to keep the stats for my own knowledge and to keep stats of the value on the ads on my site. Would it be possible to export the data into a CSV file or ODS in order to free some space but not losing that valuable data?
Comments
#1
The data is stored in a simple SQL table. Feel free to export it any way you like. I'm not sure what you're asking? The module does not provide any mechanism for automatically exporting statistics data.
#2
Hello,
Yes that is a issue for me to. My table is 300MB!
It's easy to backup the table and empty it, but I would like to keep the summarize data in the reports.
Yes there any way to do that?
Thanks,
introfini
#3
The module does not currently provide any mechanism for this, sorry. Marking as a feature request, and moving into a postponed state until someone comes along with a patch or some good ideas on how to best accomplish this.
#4
Just noticed we had nearly 9 million rows in our table... Subscribing.
#5
Yes, we need tools to purge it. Database bloating like crazy. Subscribing.
#6
Table at 700mb. Subscribing.
#7
I've added this issue which is indirectly related #881896: Aggregate statistics to reduce table size