~/talk

Alternative Datastores in WordPress

Talkat WordCamp Atlanta 2019 · 2019-05-03..05-05· [databases, wordpress]
links:none on file
slides:none on file

WordPress stores about a dozen core tables and $wpdb becomes slow when using post_meta for structured queries, so use custom tables (create via dbDelta) for fast lookups like latitude/longitude instead of longtext meta. Use ElasticSearch with geo_point or ElasticPress for sub-100ms search results but expect eventual consistency. Use Redis or memcached as an in‑memory object cache or task queue (memcached ~1MB per item, Redis higher) and avoid stuffing WP cron’s serialized blob.

AI-written summary · about

  1. 0:00Intro
  2. 1:23Talk TOC
  3. 2:24WP Storage
  4. 4:23Datastores Oversimplified
  5. 5:05Custom Tables/Views
  6. 7:53Redis/Memcached
  7. 10:56Geolocation - Rough Query
  8. 12:15Geolocation - MySQL Custom Table
  9. 13:02Geolocation - MySQL View
  10. 13:38Geolocation - Elasticsearch
  11. 14:25Geolocation - Redis
  12. 16:47Task Runner - General Concept
  13. 17:11Task Runner - WP
  14. 17:56Task Runner - MySQL
  15. 18:24Task Runner - Elasticsearch
  16. 18:39Task Runner - Redis
  17. 20:22Content Syndication - MySQL
  18. 21:43Content Syndication - Views!
  19. 22:38Content Syndication - Elasticsearch
  20. 23:41Implementation Notes
~/search
type to search 6,518 conferences, 143,918 speakers and 192,133 talks
~/help
cmdctrl k
search every conference, speaker and series
/
focus the filter search
h
home
c
conferences
s
speakers
e
series
t
light / dark — the status bar button does the same
← →
on a talk: 5 seconds back / forward
0–9
on a talk: jump to 0%–90% of the recording
?
this help
esc
close this, then clear every filter — or just the search, while you are typing in it

Ignored while you are typing. Pages without a filter rail have no search to focus.