huge node revisions table, what can i do ?

Posted by wwwoliondorcom on August 26, 2009 at 7:12pm

Hi,

My node revision table has 37000 records and 160 MiB.

Website is now super slow and most of the visitors cannot access, I repaired and optimized all the databases but it doesn't work with node_revisions, i can't repair or optimize this table.

What can I do ?

Thanks.

Comments

=-=

Posted by VM on August 26, 2009 at 7:14pm

revision deletion.module maybe ?

I don't have any node revision creation

Posted by wwwoliondorcom on August 26, 2009 at 8:37pm

Hi,

Thanks, but the problem is that i am not creating any node revision, and it seems that this table just keeps all the nodes data, even when you don't make any revision, am i wrong ?

Thanks.

=-=

Posted by VM on August 26, 2009 at 11:23pm

as far as I know that is where you content is stored at this point.