Improving wpdb queries with large data
My plugin will handle large amounts of data that could could result in the queries reading over 5000 items in a database query. The admin will provide a set of CSV files that get stored/organized in the database. The user will have some common results when they go to specific pages. I can predict what that query is in most cases. I wanted to store the array of results in cache so that query is faster.
I looked into
wp_cache_get, wp_cache_set, wp_cahce_delete, etc but it seems this may not be the best option since it’s not persistent. The codex says I would need an extra plugin to handle persistent caching but I’d rather not require ANOTHER plugin. I could store the array serialized in the database but not sure if that’s the best route for efficiency or even an acceptable workaround to the cache issue.