Performance Tuning Guide

Learn how to get the best performance out of WhoDB when working with large datasets. This guide covers WhoDB's page size settings, connection pooling behavior, caching, and practical advice for queries and exports.

For general SQL tuning — indexing, EXPLAIN plans, and query rewriting — see Query Optimization and your database's official documentation.

Page Size and Pagination

Connection Pool

Scratchpad Query Tips

Exporting Large Datasets

Caching

Memory Usage

Quick Checklist

• Page size suits your data width (lower for wide rows, large text/JSON)
• WHODB_MAX_PAGE_SIZE raised only if you actually need bigger pages
• Queries use WHERE, LIMIT, and explicit column lists
• Large exports split into filtered batches
• Database server's max_connections accounts for all clients, not just WhoDB
• Slow queries investigated with EXPLAIN and indexes on the database side

Additional Resources