QE: Optimize the compound id select #570
Labels
kind/improvement
An improvement to existing feature and code.
tech/engines/query engine
Issue in the Query Engine
Milestone
In QE when using compound ids, the related fields select does something following:
to search related records for given parent projections. This is very inefficient and will skyrocket the response times when having a larger set of projections. For now we've been optimizing the special case with just a single key with an
IN
statement that is orders of magnitude faster:We can do this with compound keys too, taking into account a slight difference how SQLite handles them, so for MySQL and PostgreSQL this will work:
But for SQLite we need
Implement optimizations for the compound ids and measure the effect with Chihiro.
The text was updated successfully, but these errors were encountered: