Home Forums ASE Support Serialized data in postmeta – how to remove Reply To: Serialized data in postmeta – how to remove

#19772

Hyun Supul

Keymaster

Hi I can’t tell you 100% sure without looking at your table entries, but those metadata you see may not have been created _directly_ by ASE, but rather indirectly by the WordPress code itself. So it’s possible other themes or plugins you use may bring back those metadata. It’s also questionable how much benefit you will gain by removing those entries. The amount of space you save would not be that significant compared to the image data themseleves. (Where each image take up hundreds of KB if not MBs, whereas an entry in DB may take up a few dozen bytes if even that.) Also when you have more entries in DB it doesn’t affect search time that much either.

Given that, it should be very possible to remove specific columns or matching data using some SQL or PHP codes. (You can use WP functions such as delete_post_meta or use SQL statments such as DELETE) If you can show me a few rows of wp_postmeta table I can give you suggestions. But bear in mind that changing DB using this kind of method is a very dangerous operation. I can’t take any responsibility whatsoever. Before you do anything you should back up your DB first.

  • This reply was modified 1 year, 10 months ago by Hyun Supul.