[BanyanDB-Server] Improve sorting and filtering performance of Stream

[hanahmily]

Search before asking

• I had searched in the issues and found no similar feature requirement.

Description

The current filtering and sorting operations scan through all parts to locate a single record in a loop. As the number of parts increases, this method can cause delays and slow down the scanning process.

To resolve this issue, the operations should refer to the standard query, which leverages the tsTableIterator to scan parts only once.

Use case

No response

Related issues

No response

Are you willing to submit a pull request to implement this on your own?

• Yes I am willing to submit a pull request on my own!

Code of Conduct

• I agree to follow this project's Code of Conduct

[wu-sheng]

Is this in 0.6 or next 0.7?

[hanahmily]

Is this in 0.6 or next 0.7?

It will be in the next one, so I didn't tag it as 0.6.

[ButterBright]

I'd like to contribute, please assign it to me.