If your WordPress admin area feels slow — especially when opening Pages — this is usually related to the total number of pages stored in your database.
This commonly happens on websites using LPagery to generate large numbers of SEO pages.
Most Common Cause: Thousands of Generated Pages
When you generate hundreds or thousands of pages with LPagery, WordPress must:
Query all pages from the database
Count published, draft, and private pages
Calculate pagination
Apply filters and sorting
Load related post meta data
WordPress is not optimized for handling tens of thousands of pages efficiently in the admin interface.
Typical Symptoms
The Pages list takes several seconds to load
Filters (All / Published / Draft) respond slowly
Admin navigation feels laggy
High database load on your hosting
Recommended Solutions
Hide Generated Pages from WordPress Admin
LPagery includes a performance feature that hides generated pages from the standard WordPress admin lists.
When enabled:
The WordPress Pages list loads significantly faster
Only manually created content appears in admin
Generated pages remain fully published and accessible
You can manage them inside the LPagery dashboard
Note: This feature is available in the Extended plan.
How to Enable
Go to LPagery → Settings
Scroll to Performance Settings
Enable Hide Generated Pages from WordPress Admin
Click Save All Settings
For installations with 10,000+ generated pages, this typically improves admin speed immediately.
Delete All Revisions (Reduce Database Size)
If your database is very large, post revisions can also slow down queries and increase hosting load.
WordPress automatically stores a revision every time a page is updated.
With thousands of LPagery-generated pages, this can result in:
A very large
wp_poststableLarge
wp_postmetatablesSlower database queries
Larger backups
What the “Delete All Revisions” Button Does
When you click Delete All Revisions in LPagery:
All revisions of LPagery-generated pages are permanently deleted
Published pages remain untouched
Page content does not change
URLs remain the same
This helps:
Reduce database size
Improve query performance
Speed up backups
Lower server load
This action is permanent.
If needed, create a database backup before running it.
How to Use
Go to LPagery → Settings
Scroll to Database Maintenance
Click Delete All Revisions
Confirm the action
Not Sure What’s Causing the Slowness?
If you're unsure whether page volume or revisions are the cause, analyze admin performance using the free plugin:
Query Monitor helps you identify:
Slow database queries
Heavy plugins
Expensive hooks
Large table scans
After installing:
Open the slow admin page
Click the Query Monitor toolbar in the admin bar
Check the Queries section
If you see large wp_posts queries scanning thousands of rows, the slowdown is likely related to page volume.
Other Possible Causes
If the above measures do not resolve the issue, it may be related to:
Limited hosting resources (low RAM / CPU)
Slow database server
Too many active plugins
Very large
wp_postmetatablesHeavy admin-side builders
Will This Affect My Website or SEO?
No.
All generated pages remain published
Visitors can access them normally
Search engines can crawl and index them
Only the WordPress admin interface is affected