Hi,
VB 5.1.6, I've been a VB user for... probably a decade? My database is 2.5G and I need to get it under (and keep it under) 1G. I've done a couple hours of research, have my attachments, avatars, and other pictures stored in the file system instead of the database. I pruned whatever tables I could confirm weren't needed in this version, and I've increased my search indexing to words of 4 letters minimum and decreased the max to 10.
What else can I do? My largest tables are closure (388M), node (344M), text (297M), cache (134M), and cacheevent (118M).
I am not finding a reasonable way to prune old posts, but have started trying to delete older forums that aren't used much any more - it's had a negligible impact thus far.
Let me know what other questions you have, or if there's anything else I can do to help you help me.
Timothy
VB 5.1.6, I've been a VB user for... probably a decade? My database is 2.5G and I need to get it under (and keep it under) 1G. I've done a couple hours of research, have my attachments, avatars, and other pictures stored in the file system instead of the database. I pruned whatever tables I could confirm weren't needed in this version, and I've increased my search indexing to words of 4 letters minimum and decreased the max to 10.
What else can I do? My largest tables are closure (388M), node (344M), text (297M), cache (134M), and cacheevent (118M).
I am not finding a reasonable way to prune old posts, but have started trying to delete older forums that aren't used much any more - it's had a negligible impact thus far.
Let me know what other questions you have, or if there's anything else I can do to help you help me.
Timothy
Comment