Filtered lookup fields too slow

By: Alan Kindree | Asked: 04/27/2023
ForumsCategory: General questionsFiltered lookup fields too slow
Alan KindreeAlan Kindree asked 12 months ago
Hi, I have lookup fields with filters on them.  They take forever to load.  Is there any way to speed this up?  What is the best settings to use for filtering? Cheers Alan
1 Answers
Victor Font answered 12 months ago
If the filters are complex, you can try using SQL Views instead of letting Formidable create the SQL on the fly. SQL views are executed at runtime in the DB Engine. It provides much faster performance than handing off between WordPress/MySQL. You can use the $wpdb global object to call SQL views directly from the frm_setup_new_fields_vars and frm_setup_edit_fields_vars filters.
Alan KindreeAlan Kindree replied 12 months ago

<p>Thanks again Victor! You are always very helpful. I will try that once I work myself up to that pay grade. Cheers! For now I am making a lot of fields with conditional logic to pre-sort the data and not use the filters. Some day though....</p><p>I also noticed that my site would shut down over too many requests when using filters.  I suspect WP & Formidable going back and forth during the filtering was overloading my bandwidth.  Is that possible?</p>

Making the Best WordPress Plugin even better - Together

Take on bigger projects with confidence knowing you have access to an entire community of Formidable Experts and Professionals who have your back when the going gets tough. You got this!
Join the community