Hi guys!
Been having big delays and connection timeout errors on my P202 on the last few days when i haven't been pushing more than 30K clicks a day.
Consulting with BeyondHosting, my database which is now 728MB in size, is causing this.. Although Ive been able to run after they looked into something, same thing happened again.
I was wondering if there is a list of tables which are OK to empty from the 202 db?
http://www.imkazu.com/archiving-your...ata-for-speed/
Says to empty 202_clicks and 202_clicks_spy.
http://www.jim.am/tag/202_site_urls/
Says to empty 202_site_urls
Thanks!
I also empty the table "202_ips".
Btw, i think 202_clicks is your clickdata, so i wouldn't delete that too often.