This will still allow for duplicates for a single meta_key for the same post_id. If you have already millions of entries in your tables, you need to make sure the fields used for the new indexes aren’t NULL.
This should preferably be done on a fresh installation.
If you want more details read this explanation and if you just want to fix the MySQL indexes, then backup your database then run these MySQL statements (with caution): Optimise and rebuild WordPress Meta Table Indexes. I’ve been working on a shop with many gigabytes of postmeta tables, which will reduce site responsiveness or worse make certain parts or your entire site unusable at all. But there’s things one can do to improve the performance anyways. It’s antiquated, outdated and very very far from optimal. Necessities like the metaeditor with built-in beat detection and tools for fast trimming, fading, slicing, and dicing your sounds.The database architecture of WordPress looks essentially the same it did 15 years ago in v3.x. Speaking of plug-ins, AudioFinder features an advanced plug-in manager and a slew of other studio necessities that will make your workflow flow.
Sounds can even be previewed through your favorite AudioUnits.
Use it to create custom sets for sound categories and specific projects, with fast file browsing to audition, analyze, process, convert, and move or copy the samples in your library.ĪudioFinder can visualize sounds instantly with the waveform overview and preview them at any pitch via MIDI or the built in keyboard, all in real-time. It gathers all the most useful tools in one quick and intuitive application, enabling you to be more creative by handling all the time consuming tasks that slow down your music production.ĪudioFinder can build a catalog of every sound on your system, save it, and search it instantly to find the sounds you need when you need them. AudioFinder is an audio asset management system and music production hub.