DigitalfastmindQ: Database Size
Hi!
since all the data is stored in the DB i wish to avoid it for growing and for WP to be bloated.
Questions:
- Which data table is affected and where data is stored in the DB?
-Can it automatically clean/flush analytics or there is a custom function to make sure things are kept lean?
Thanks!
Jordy_LinkCentral
Nov 2, 2025A: Hi, thanks for your question! I'll try to answer it in as much detail as possible:
LinkCentral uses the standard WordPress tables such as:
- wp_posts and wp_postmeta for storing links (as they’re a custom post type)
- wp_options for plugin settings
It also creates two additional tables: one for click data (statistics) and another for automated keyword linking.
And yes, there are several cleanup options to prevent your database from getting too bloated:
- Delete specific data: You can delete only click data, or all plugin data (links, categories, and click data, but settings are kept) with a simple click.
- Automatic cleanup: Old analytics can be automatically removed after 3, 6, or 12 months.
- Per-link cleanup option: When a link is deleted, related analytics can be removed automatically so no orphaned data remains.
Thanks, it's indeed interesting but the wp_postmeta and wp_posts would become huge. It's not easy but i think wp_postmeta and wp_posts have to be as much light as possible! How can we tackle that? Good stuff about orphan data clean!
LinkCentral uses wp_posts & wp_postmeta because it’s built as a WordPress Custom Post Type. This provides the benefits of WP's built-in features, extendability through plugins like ACF & Pods, and compatibility with dynamic data in theme builders. It’s an intentional architectural choice. The table size depends on your number of links but cleanup plugins could manage autosaves/revisions.
Sure, Metabox and ACPT (new feature coming soon) supports also advanced additional tables. Worth checking. Still i am happy to purchase and test. Last : i see an unlimited LTD plan on your site, will you run a BF deal on that package?
Awesome, happy to hear that! If you have any questions while trying out LinkCentral, feel free to reach out.
Sure what about the web unlimited package on your site? Any BF extra discounted deal on the way?
Yes, there will be a Black Friday sale starting around mid-November. For more info feel free to reach out to me at jordy [at] designforwp.com.
I'll keep an eye on it! :)