[Resolved] Custom search – input values ​​no automatic update with more than 6000 posts

[Author]

Posts

[sebastienD-8]

Tell us what are you trying to do?

A search form with filters. It works perfectly with less than 2000 jobs, but with 6000 jobs the fields are empty.

Is there a solution to work around the problem?

hidden link

[Minesh]

Hello. Thank you for contacting the Toolset support.

Dealing with such mass content is always a issue. It really depends on the server resource and how much memory do you have.

Can you please try to raise the memory limit on your server. I'm not sure how much memory do you have.

Here is the Doc that shows few hints how you can use custom search on large sites:
- https://toolset.com/documentation/legacy-features/views-plugin/how-to-use-views-parametric-search-on-large-sites/

Do you see any error with your PHP or server error logs? if yes, could you please share that so we can know whats actually failing.

I would like to have debug information that will help us to debug and investigate your issue:
- https://toolset.com/faq/provide-debug-information-faster-support/

[sebastienD-8]

WP Memory Limit > 512 MB
The site is hosted on wpengine.com, I don't think I can increase this value further

PHP Log error

{ "installName": "equanslpcomdev",
"environment": "DEV",
"type": "error",
"date": "2022-04-29T13:05:38.000Z",
"severity": "notice",
"client": "149.154.251.217:0",
"message": "KILLED QUERY (40224 characters long generated in /nas/content/live/equanslpcomdev/wp-content/plugins/toolset-blocks/embedded/inc/classes/wpv-cache.class.php:216): SELECT post_id, meta_key, meta_value FROM wp_postmeta\\n\\t\\t\\t\\t\\tWHERE post_id IN (29319,29320,29312,29313,29314,29315,29316,29317,29318,29300,29301,29302,29303,29304,29305,29306,29307,29308,29292,29299,29275,29276,29277,29278,29279,29280,29281,29282,29291,29267,29252,29268,29253,29269,29254,29270,29255,29271,29256,29257,29258,29259,29260,29261,29262,29263,29264,29265,29266,29235,29251,29236,29237,29238,29239,29240,29241,29242,29243,29244,29245,29246,29247,29232,29248,29233,29249,29234,29250,29219,29220,29221,29222,29223,29224,29225,29226,29227,29212,29228,29213,29229,29214,29230,29215,29231,29216,29217,29218,29203,29204,29205,29206,29207,29192,29208,29193,29209,29194,29210,29195,29211,29196,29197,29198,29199,29200,29201,29202,29187,29172,29188,29173,29189,29174,29190,29175,29191,29176,29177,29178,29179,29180,29181,29182,29183,29184,29185,29186,29155,29171,29156,29157,29158,29159,29160,29161,29162,29163,29164,29165,29166,29167,29152,29168,29153,29169,29154,29170,29139,29140,29141,29142,29143,29144,29145,29146,29147,29132,29148,29133,29149,29134,29150,29135,29151,29136,29137,29138,29123,29124,29125,29126,29127,29112,29128,29113,29129,29114,29130,29115,29131,29116,29117,29118,29119,29120,29121,29122,29107,29092,29108,29093,29109,29094,29110,29095,29111,29096,29097,29098,29099,29100,29101,29102,29103,29104,29105,29106,29075,29091,29076,29077,29078,29079,29080,29081,29082,29083,29084,29085,29086,29087,29072,29088,29073,29089,29074,29090,29059,29060,29061,29062,29063,29064,29065,29066,29067,29052,29068,29053,29069,29054,29070,29055,29071,29056,29057,29058,29043,29044,29045,29046,29047,29032,29048,29033,29049,29034,29050,29035,29051,29036,29037,29038,29039,29040,29041,29042,29027,29012,29028,29013,29029,29014,29030,29015,29031,29016,29017,29018,29019,29020,29021,29022,29023,29024,29025,29026,28995,29011,28996,28997,28998,28999,29000,29001,29002,29003,29004,29005,29006,29007,28992,29008,28993,29009,28994,29010,28979,28980,28981,28982,28983,28984,28985,28986,28987,28972,28988,28973,28989,28974,28990,28975,28991,28976,28977,28978,28963,28964,28965,28966,28967,28952,28968,28953,28969,28954,28970,28955,28971,28956,28957,28958,28959,28960,28961,28962,28947,28932,28948,28933,28949,28934,28950,28935,28951,28936,28937,28938,28939,28940,28941,28942,28943,28944,28945,28946,28915,28931,28916,28917,28918,28919,28920,28921,28922,28923,28924,28925,28926,28927,28912,28928,28913,28929,28914,28930,28899,28900,28901,28902,28903,28904,28905,28906,28907,28892,28908,28893,28909,28894,28910,28895,28911,28896,28897,28898,28883,28884,28885,28886,28887,28872,28888,28873,28889,28874,28890,28875,28891,28876,28877,28878,28879,28880,28881,28882,28867,28852,28868,28853,28869,28854,28870,28855,28871,28856,28857,28858,28859,28860,28861,28862,28863,28864,28865,28866,28835,28851,28836,28837,28838,28839,28840,28841,28842,28843,28844,28845,28846,28847,28832,28848,28833,28849,28834,28850,28819,28820,28821,28822,28823,28824,28825,28826,28827,28812,28828,28813,28829,28814,28830,28815,28831,28816,28817,28818,28803,28804,28805,28806,28807,28792,28808,28793,28809,28794,28810,28795,28811,28796,28797,28798,28799,28800,28801,28802,28787,28772,28788,28773,28789,28774,28790,28775,28791,28776,28777,28778,28779,28780,28781,28782,28783,28784,28785,28786,28755,28771,28756,28757,28758,28759,28760,28761,28762,28763,28764,28765,28766,28767,28752,28768,28753,28769,28754,28770,28739,28740,28741,28742,28743,28744,28745,28746,28747,28732,28748,28733,28749,28734,28750,28735,28751,28736,28737,28738,28723,28724,28725,28726,28727,28712,28728,28713,28729,28714,28730,28715,28731,28716,28717,28718,28719,28720,28721,28722,28707,28692,28708,28693,28709,28694,28710,28695,28711,28696,28697,28698,28699,28700,28701,28702,28703,28704,28705,28706,28675,28691,28676,28677,28678,28679,28680,28681,28682,28683,28684,28685,28686,28687,28672,28688,28673,28689,28674,28690,28659,28660,28661,28662,28663,28664,28665,28666,28667,28652,28668,28653,28669,28654,28670,28655,28671,28656,28657,28658,28643,28644,28645,28646,28647,28632,28648,28633,28649,28634,28650,28635,28651,28636,28637,28638,28639,28640,28641,28642,28627,28612,28628,28613,28629,28614,28630,28615,28631,28616,28617,28618,28619,28620,28621,28622,28623,28624,28625,28626,28595,28611,28596,28597,28598,28599,28600,28601,28602,28603,28604,28605,28606,28607,28592,28608,28593,28609,28594,28610,28579,28580,28581,28582,28583,28584,28585,28586,28587,28572,28588,28573,28589,28574,28590,28575,28591,28576,28577,28578,28563,28564,28565,28566,28567,28552,28568,28553,28569,28554,28570,28555,28571,28556,28557,28558,28559,28560,28561,28562,28547,28532,28548,28533,28549,28534,28550,28535,28551,28536,28537,28538,28539,28540,28541,28542,28543,28544,28545,28546,28515,28531,28516,28517,28518,28519,28520,28521,28522,28523,28524,28525,28526,28527,28512,28528,28513,28529,28514,28530,28499,28500,28501,28502,28503,28504,28505,28506,28507,28492,28508,28493,28509,28494,28510,28495,28511,28496,28497,28498,28483,28484,28485,28486,28487,28472,28488,28473,28489,28474,28490,28475,28491,28476,28477,28478,28479,28480,28481,28482,28467,28452,28468,28453,28469,28454,28470,28455,28471,28456,28457,28458,28459,28460,28461,28462,28463,28464,28465,28466,28435,28451,28436,28437,28438,28439,28440,28441,28442,28443,28444,28445,28446,28447,28432,28448,28433,28449,28434,28450,28419,28420,28421,28422,28423,28424,28425,28426,28427,28412,28428,28413,28429,28414,28430,28415,28431,28416,28417,28418,28403,28404,28405,28406,28407,28392,28408,28393,28409,28394,28410,28395,28411,28396,28397,28398,28399,28400,28401,28402,28387,28372,28388,28373,28389,28374,28390,28375,28391,28376,28377,28378,28379,28380,28381,28382,28383,28384,28385,28386,28355,28371,28356,28357,28358,28359,28360,28361,28362,28363,28364,28365,28366,28367,28352,28368,28353,28369,28354,28370,28339,28340,28341,28342,28343,28344,28345,28346,28347,28332,28348,28333,28349,28334,28350,28335,28351,28336,28337,28338,28323,28324,28325,28326,28327,28312,28328,28313,28329,28314,28330,28315,28331,28316,28317,28318,28319,28320,28321,28322,28307,28292,28308,28293,28309,28294,28310,28295,28311,28296,28297,28298,28299,28300,28301,28302,28303,28304,28305,28306,28275,28291,28276,28277,28278,28279,28280,28281,28282,28283,28284,28285,28286,28287,28272,28288,28273,28289,28274,28290,28259,28260,28261,28262,28263,28264,28265,28266,28267,28252,28268,28253,28269,28254,28270,28255,28271,28256,28257,28258,28243,28244,28245,28246,28247,28232,28248,28233,28249,28234,28250,28235,28251,28236,28237,28238,28239,28240,28241,28242,28227,28212,28228,28213,28229,28214,28230,28215,28231,28216,28217,28218,28219,28220,28221,28222,28223,28224,28225,28226,28195,28211,28196,28197,28198,28199,28200,28201,28202,28203,28204,28205,28206,28207,28192,28208,28193,28209,28194,28210,28179,28180,28181,28182,28183,28184,28185,28186,28187,28172,28188,28173,28189,28174,28190,28175,28191,28176,28177,28178,28163,28164,28165,28166,28167,28152,28168,28153,28169,28154,28170,28155,28171,28156,28157,28158,28159,28160,28161,28162,28147,28132,28148,28133,28149,28134,28150,28135,28151,28136,28137,28138,28139,28140,28141,28142,28143,28144,28145,28146,28115,28131,28116,28117,28118,28119,28120,28121,28122,28123,28124,28125,28126,28127,28112,28128,28113,28129,28114,28130,28099,28100,28101,28102,28103,28104,28105,28106,28107,28092,28108,28093,28109,28094,28110,28095,28111,28096,28097,28098,28083,28084,28085,28086,28087,28072,28088,28073,28089,28074,28090,28075,28091,28076,28077,28078,28079,28080,28081,28082,28067,28052,28068,28053,28069,28054,28070,28055,28071,28056,28057,28058,28059,28060,28061,28062,28063,28064,28065,28066,28035,28051,28036,28037,28038,28039,28040,28041,28042,28043,28044,28045,28046,28047,28032,28048,28033,28049,28034,28050,28019,28020,28021,28022,28023,28024,28025,28026,28027,28012,28028,28013,28029,28014,28030,28015,28031,28016,28017,28018,28003,28004,28005,28006,28007,27992,28008,27993,28009,27994,28010,27995,28011,27996,27997,27998,27999,28000,28001,28002,279",
"uuid": "676aa0d7-81b5-4717-9ed0-827a3aa87eeb"
}

can this help?

[Minesh]

Can you please try to add the following line of code to your wp-config.php file:

define( 'WPE_GOVERNOR', false );

If that does not help, you will require to show the error you shared with me about Killed Query to WPEngine support and they should actually the right person to guide you to resolve this as this is server related configuration issue.

[sebastienD-8]

It didn't change anything

On the other hand, when I deactivate WPML, the fields work again with 6000 jobs.

an idea? too heavy with wpml?

[Minesh]

I see number of tickets related to the same issue, can you please try to follow the guide given with the following link and check if that help you to resolve the issue.

Please take full backup of your database first so in any worst case you can restore it:
- https://wpml.org/forums/topic/killed-query-on-wp_engine/

[sebastienD-8]

Great, this solved the problem, many thanks and have a nice day!

[sebastienD-8]

My issue is resolved now. Thank you!