Resolving OOM and Connection Leaks

OutOfMemoryError (OOM)

TeaQL prevents N+1 queries through efficient batch loading. However, if you attempt to load millions of records into memory at once without pagination, you will encounter OutOfMemoryError.

Solution: Use .limit() and .offset() in your queries, or use cursor-based pagination.

Connection Pool Leaks

TeaQL manages database connections automatically within the UserContext. If you are using custom provider implementations, ensure you properly release connections back to the HikariCP pool.