Skip Navigation

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

This support ticket is created 3 years, 9 months ago. There's a good chance that you are reading advice that it now obsolete.

This is the technical support forum for Toolset - a suite of plugins for developing WordPress sites without writing PHP.

Everyone can read this forum, but only Toolset clients can post in it. Toolset support works 6 days per week, 19 hours per day.

Sun Mon Tue Wed Thu Fri Sat
- 10:00 – 13:00 10:00 – 13:00 10:00 – 13:00 10:00 – 13:00 10:00 – 13:00 -
- 14:00 – 18:00 14:00 – 18:00 14:00 – 18:00 14:00 – 18:00 14:00 – 18:00 -

Supporter timezone: Asia/Kolkata (GMT+05:30)

This topic contains 7 replies, has 2 voices.

Last updated by sebastienD-8 3 years, 9 months ago.

Assisted by: Minesh.

Author
Posts
#2352375

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

#2352443

Minesh
Supporter

Languages: English (English )

Timezone: Asia/Kolkata (GMT+05:30)

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/

#2352463

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?

#2352465

Minesh
Supporter

Languages: English (English )

Timezone: Asia/Kolkata (GMT+05:30)

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.

#2352467

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?

#2352483

Minesh
Supporter

Languages: English (English )

Timezone: Asia/Kolkata (GMT+05:30)

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/

#2352503

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

#2352505

My issue is resolved now. Thank you!