0xMiden / 0xMiden/node

db/limits: Limit SQL query results

Open
#1,467 2 comments 1 reaction 0 assignees View on GitHub
store
Dominant language
Rust
Stars
104
Forks
138
Avg merge
1d 13h
Merged PRs (30d)
56

Description

At the RPC level we do have the notion of `too_many_entries`, however, to come to the decision we already did a full SQL query of i.e. all assets.

## Proposal

Limit the SQL queries to `N+1` entries, where `N` is the maximum number we would return without yielding a `too_many_entries` response to the requester. That way we don't burn CPU cycles on very large assets.

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.