SIZE OF TABLE

Hi,

2 Tables are very very big !!!  (100 members since 1 month)

bx_spy_friends_data   100 Mo

bx_spy_data   30 Mo

Can i empty these tables ?

Thanks...

Affichage des enregistrements 0 - 29 (2 068 051 total, Traitement en 0.0003 sec.)

Affichage des enregistrements 0 - 29 (93 147 total, Traitement en 0.0002 sec.)

^^

outch...

You can empty them but you would loose all spy data such as 'member1 has view member2's profile', etc. I think there should be a way that Dolphin would only store maybe like 30 days of spy data.

Im sure that maybe you could create a cron job that would purge the data from those tables if the values were > GETDATE() - 30

(greater that 30 days)

Ticket added: http://www.boonex.com/trac/dolphin/ticket/2021 (Pruning options for Spy module)

An easy solution, until we will have some pruning options in Spy module, is to use the following request using phpMyAdmin (replace the xxxxx with the id number of the first record id you want to keep - for example, if you replace xxxxx with 2000, records id 1 to 1999 will be deleted):

DELETE FROM `bx_spy_data` WHERE `bx_spy_data`.`id` < xxxxx;
DELETE FROM `bx_spy_friends_data` WHERE `bx_spy_friends_data`.`id` < xxxxx;

Of course, Zarcon is right. But for now I don't know how to create such cron job...

Yes is a good idea there will need to clean all of that

OKi... Thanks a lot !

There are at least 2 other tables that are growing fast !!!

bx_wall_events and sys_sessions ...

Request for some pruning feature was added to ticket #2021

I completed the request to run using phpMyAdmin (replace the xxxxx with the id number of the first record id you want to keep - for example, if you replace xxxxx with 2000, records id 1 to 1999 will be deleted / as for sys_sessions table, the request is based on the date column):

DELETE FROM `bx_spy_data` WHERE `bx_spy_data`.`id` < xxxxx;
DELETE FROM `bx_spy_friends_data` WHERE `bx_spy_friends_data`.`id` < xxxxx;
DELETE FROM `bx_wall_events` WHERE `bx_wall_events`.`id` < xxxxx;

! Be cautious with this one as it will delete Last logged date info !

DELETE FROM `sys_sessions` WHERE `sys_sessions`.`date` < xxxxxxxxxx;