Hi, am using Simpleads for a long time, I have one block with about 5 ads in there.
Recently I found out that my DB is using too much space, and to my surprise the biggest table in my Drupal DB is "simpleads_impressions", taking 11MB! That's like 1/3 of my whole DB size!
Is there some way we can make the table smaller? Store less data? Delete old data (for ads from the past / deleted)?
I think 11 MB is way to big for one DB table...

Comments

mrpeanut’s picture

mrpeanut commented

I'm wondering the same thing. Can I simply truncate (empty) that table every now and then? We don't really use the impressions anyway.

minnur’s picture

minnur commented

Related to #1876732: Simpleads campaigns CPU usage skyrockets after lots of ad impressions

mrpeanut’s picture

mrpeanut commented

@minnur — If we're not using campaigns, is it safe to truncate (empty) that table? (My table is ~7,128,687 rows and 546.1 MiB, so you can understand why I want to empty it. :) )

minnur’s picture

minnur commented

@MrPeanut, yes it is safe to truncate the table. I had about 32M records...This problem fixed in dev version.

minnur’s picture

minnur commented
Issue summary: View changes
Status: Active » Closed (won't fix)