You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
e.g. pagination, the read speed slower compared to the top rows.
In the future, we can develop local cache mode to record the stream position of zip rows.
It can get better speed when second query after first query cache created.
Caching would be impractical for big datasets, but we could look into implementing a custom IQueryable to avoid having to process rows that are meant to be skipped. Not an easy feat though, it's gonna take a lot of work.
@michelebastione good day 🙌
I remember I had implemented skip function, but it also needs lots time when N times skipping in large file.
So I would like to provide configuration for user space to change speed. (zip location int dictionary)
But it just a idea, and I don't need the feature, because I prefer DB not excel to resolve the problem. (ZIP not like DB architecture)😂
Activity
[-]Optimize Query page query speed by cache mode option[/-][+]Optimize Queries by caching/pagination[/+]michelebastione commentedon Apr 20, 2026
Caching would be impractical for big datasets, but we could look into implementing a custom IQueryable to avoid having to process rows that are meant to be skipped. Not an easy feat though, it's gonna take a lot of work.
shps951023 commentedon Apr 20, 2026
@michelebastione good day 🙌
I remember I had implemented skip function, but it also needs lots time when N times skipping in large file.
So I would like to provide configuration for user space to change speed. (zip location int dictionary)
But it just a idea, and I don't need the feature, because I prefer DB not excel to resolve the problem. (ZIP not like DB architecture)😂