[Nurbis]

4 years, 2 months ago #10780

Hello,

I just installed the plugin and noticed one problem. When I want to visit “Define Your Search” – “Data” (2.2. page), the page is loading a while and then I get error 500.

Could it be because I’ve got too many posts on my wordpress (150 000) ? Or is there something else ?

[wpsolr]

4 years, 2 months ago #10781

Hello,

It should not be the number of posts. We have clients with millions of posts/products/topics.

Do you get errors in WP debug.log?

[wpsolr]

4 years, 2 months ago #10782

What are your versions of WP, and PHP?

[Nurbis]

4 years, 2 months ago #10783

Hi,

WP: 5.0.3
PHP: 7.0.28

[wpsolr]

4 years, 2 months ago #10785

I suspect a lot of data is in your metas table.

Please try to execute the SQL on your WP:

SELECT distinct meta_key
FROM wp_posts as POSTS
INNER JOIN wp_postmeta AS POSTMETAS ON POSTS.ID = POSTMETAS.post_id
WHERE POSTS.post_type = 'post'

You can also install https://wordpress.org/plugins/query-monitor/ and check the longest queries.

• This reply was modified 4 years, 2 months ago by wpsolr.

[Nurbis]

4 years, 2 months ago #10792

Hi, I run the query:
(399249 rows total, Query took 2.7871 seconds.)

So yeah, a lot 🙂

[wpsolr]

4 years, 2 months ago #10793

This query returned 399249 rows?

This would mean your posts have 399249 custom field definitions (not content, definition).
This is not possible.

[Nurbis]

4 years, 2 months ago #10801

Well I did clean the meta keys (via WP-sweep plugin) and can now access the 2.2 page 🙂
So thanks for the tip.

[wpsolr]

4 years, 2 months ago #10802

WP-Sweep

Amazing. I added the plugin’s link for other readers.