WordPress / wordpress-playground

Run WordPress in the browser via WebAssembly PHP
https://w.org/playground/
GNU General Public License v2.0
1.65k stars 263 forks source link

CORS Proxy: Index update_at column because it is used for lookup #1931

Closed brandonpayton closed 1 month ago

brandonpayton commented 1 month ago

Motivation for the change, related issues

The CORS proxy regularly deletes rate-limiting records over a day old, and the updated_at column is not indexed even though it is used for looking up entries that can be deleted.

Closes #1921.

Implementation details

This PR updates the table creation SQL to add an index for the updated_at column.

Testing Instructions (or ideally a Blueprint)