Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Limit performance increase + Bugfix for many #4

Merged
merged 3 commits into from Sep 13, 2022

Conversation

Valerionn
Copy link
Contributor

depends on #3 for additional benchmarking (therefore this PR contains the other changes as well until it's merged).

I have changed limitItems to need way less array operations when limiting/paginating a large item data set.

I also fixed a bug with many which didn't return any items if filter options are defined but don't contain a where (e.g. when paginating the whole data set).

many query with limit:

Before

  blinkdb   took 0.41430ms, high 16.08050ms, low 0.40960ms

After

  blinkdb   took 0.19070ms, high 2.21160ms, low 0.17670ms

Fix a bug that caused indexed entries to not be deleted correctly from the index
Fix a bug with `many` not returning any items if options are specified but no `where` is defined
@netlify
Copy link

netlify bot commented Sep 13, 2022

Deploy Preview for blinkdb canceled.

Name Link
🔨 Latest commit 545de54
🔍 Latest deploy log https://app.netlify.com/sites/blinkdb/deploys/631fd64bf0895a0009601367

@Valerionn Valerionn changed the title Limit performance increase Limit performance increase + Bugfix for many Sep 13, 2022
@froehlichA
Copy link
Contributor

Performance increases on sort and limit are always welcome, primarily because those are the least optimized parts of the query engine ^^

@froehlichA
Copy link
Contributor

As far as I can tell, the first commit in this PR is from #3, and the other two look fine as is.
I'll merge this after #3 is done.

@froehlichA froehlichA merged commit 9e74f5d into blinkdb-js:main Sep 13, 2022
@Valerionn Valerionn deleted the limit-performance-increase branch September 13, 2022 20:38
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

Successfully merging this pull request may close these issues.

None yet

2 participants