This new version of Livebase generates applications with better performance on complex queries over large datasets. In order to achieve this result we have conceived and implemented a technique for breaking down the original query into multiple (simpler) sub-queries that could be executed in parallel more efficiently, and for recombining the results in memory.
The idea behind this technique is to execute a different sub-query to retrieve a subset of the patient’s derived attributes (i.e. a subset of the columns of the original record set) connected through the same path over the data-model (i.e. retrievable via the same chain of relational joins over the database). In some specific queries defined on complex models, the new technique that has been implemented proved to be up to 40 times faster.