Investigate performance impact of improved database indices

GravityKit / GravityView

The best and easiest way to display Gravity Forms entries on your website.

https://www.gravitykit.com/products/gravityview/

245 stars 63 forks source link

Investigate performance impact of improved database indices #2092

Open zackkatz opened 3 months ago

zackkatz commented 3 months ago

Describe the Issue

Inspired by #2089, we need to investigate the performance impact of adding additional indices to the Gravity Form database tables.

Prepopulate databases with lots of data
Write tests that simulate a variety of GravityView queries, including Maps, Multiple Forms, Advanced Filters, and search
Compare performance with different index structures

rafaehlers commented 3 months ago

I applied these indices to a customer website, and they worked wonderfully. We should consider applying this solution to GV:

CREATE INDEX idx_entry_meta_value ON wp_gf_entry_meta (entry_id, meta_key, meta_value(191));
CREATE INDEX idx_meta_entry ON wp_gf_entry_meta (meta_key, entry_id);
CREATE INDEX idx_form_status_created_by ON wp_gf_entry (form_id, status, created_by, id);