aries-askar icon indicating copy to clipboard operation
aries-askar copied to clipboard

Published 20 hours ago • verified publisher icon hyperledger

Query optimization

Open MaticDiba opened this issue 3 years ago • 2 comments

When querying for wallet items we found out that some queries that are generated by WQL are not optimized. Are there any initiatives planned to tackle that issue? Having a large number of profiles with multiple items and tags, this could become an issue for the performance.

MaticDiba avatar Aug 11 '21 12:08 MaticDiba

Do you have an example of a query that needs optimizations? There are some basic ones applied, but nothing very advanced.

andrewwhitehead avatar Aug 11 '21 16:08 andrewwhitehead

One example is here: https://github.com/hyperledger/aries-askar/blob/main/src/storage/wql/sql.rs#L188

This nesting in join condition can become problematic.

MaticDiba avatar Aug 13 '21 10:08 MaticDiba