Log in

View Full Version : Attachments in filesystem // Database size


tutorials.de
01-31-2006, 10:22 AM
Hi guys,

some time ago, we moved all our attachments from our database into the filesystem. The system is working pretty well but the attachment table is still really big (600 MB).

In my opinion, all attachments which have been saved in the system before the database-into-filesystem-change, are still in that table.

How can I delete the data from that table? (No, I don't want to delete all attachments - only the multiple, unused data in the attachment table).

Cheers,
Arne

tutorials.de
02-04-2006, 04:16 AM
Any idea?

b00k
07-03-2006, 05:48 PM
..................

Zachery
07-03-2006, 06:36 PM
Assuming you did finlize the export did you also optmize the database?