Very good beta version.

Missing Features 1. Global search (highest priority)

Currently the table only lists meta keys.

Users cannot quickly search for:

• meta key
• plugin name
• post type
• sample value

A live search box filtering the table instantly would probably become one of the most used features.

2. Advanced filtering

Current view only supports pagination.

Useful filters would be:

• Post type
• Plugin / Source
• Empty values only
• Unknown meta keys
• Only orphaned meta
• Keys used less than X times
• Keys used more than X times

This would make large WooCommerce databases much easier to clean.

3. Sortable columns

Currently everything is alphabetical.

Allow sorting by:

• Meta key
• Count
• Plugin
• Post type
• Estimated database size

4. Database size column

This is probably the biggest missing feature.

Instead of only showing:

_count = 12,354

show

12,354 rows
34.7 MB

5. Last modified information

Show:

• newest post
• oldest post
• last modified

Which posts use this key?

Very valuable.

Example:

Used on

✓ Products (18,322)
✓ Orders (54,123)
✓ Pages (16)

Then

View posts

could open the actual post list.

********

Performance Improvements

1. Lazy loading

Currently the dashboard loads every meta key, then paginates in PHP.

2. Cache source lookup

Current implementation loops through every prefix until a match is found.

foreach(prefixes)

for every row.

Instead cache

meta_key
↓

plugin

during rendering.

Minor improvement.

3. Progress bar

Instead of

Processing...

show

34%

4200 / 12344

ETA 12 sec

4. Incremental refresh

Current refresh rebuilds the whole dataset.

A smarter refresh would update only changed keys.

5. Database indexes analysis

Detect missing indexes.

Example

Your wp_postmeta table has no composite index

Recommended:

(meta_key, post_id)

Could dramatically speed up operations on very large WooCommerce stores.

• This topic was modified 4 days, 10 hours ago by parittyako1.