thinkshout / wp-otis

WordPress plugin for the Oregon Tourism Information System
GNU General Public License v2.0
4 stars 1 forks source link

Review meta query performance in Otis_Importer #22

Closed BrendanJercich closed 2 months ago

BrendanJercich commented 2 years ago

In the process of work to reduce memory-exceeded errors and timeouts, James changed a single large meta WP_Query into a foreach loop of one-post-each meta queries. It may well be that this is a performance improvement, or that its impact depends on the environment (eg the presence or absence of memcaching), but it's also possible that this will cause issues with SQL. We should set some timers and count the execution time necessary for the same import conditions under both options.