CSV Import Data

Hi Daniel,

Thank you for your message.

I visited the Import CSV File page and this did indeed remove the records from the database table so I can now see _csv_import_data (0) in the list of Section Editors. However the table size is still being displayed as 1.6MB. Do you know why this might be if there are no records in the table?

Thank you for your assistance.

Regards,

Greg

Hi Greg,

This is likely being caused by table "overhead" which will commonly happen when deleting records; the section editor reports the total space that the table is using on the disk, which may not be the same as the space taken up by data/records. You can confirm if this is the case in phpMyAdmin by checking under the "overhead" column when viewing the list of tables in a database. To get rid of overhead, simply check the box beside the table, and select "Optimize table" from the drop-down near the bottom of the page.

Overhead generally isn't of critical concern, unless it starts taking up a significant amount of disk space, or the table is performing poorly. However, there's no harm in periodically optimizing tables with overhead, and it may improve performance depending on table size/usage. Overhead won't contribute to the size of database backups.

Let me know if you have any further questions!

Thanks,

Hi Daniel,

Thank you very much for the very clear explanation, that's really good to know. I have just run the optimize command and it's cleared the overhead. I have often wondered about the "Optimize" feature in phpMyAdmin, that's great!

Regards,

Greg