nosqlclient icon indicating copy to clipboard operation
nosqlclient copied to clipboard

Need to wait loading to perform a query on large collections

Open alexandre-slp opened this issue 5 years ago • 3 comments

Expected Behavior

Run a simple query on a large collection.

Current Behavior

When the query screen opens it start a process that the "Execute" button is replaced with "loading" gif and while its loading, its not possible to perform the query. This loading time is proportional to the collection size and on very large collections the loading time is greater than 5 minutes!!!

Possible Solution

I can think on 1 solution:

  • Make this process non blocking for querying

I think this process collect statistics from the collection.

image

Context

It's very frustrating needing to wait for minutes just to perform a simple query.

Your Environment

  • Nosqlclient version used: 4.0.1
  • Environment name (e.g. chrome 39, portable, docker): docker
  • Operating System and version (e.g. windows 10, ubuntu 16, osx 10.12): ubuntu 20

alexandre-slp avatar Apr 01 '21 12:04 alexandre-slp

Hi @alexandre-slp I remember there was a workaround for this, isn't there a setting to disable fetching these values in the settings?

rsercano avatar Apr 01 '21 13:04 rsercano

I think you are talking about this one:

image

Its already unchecked but this is related to the statistics shown in the main page not the one shown in my last picture.

alexandre-slp avatar Apr 01 '21 13:04 alexandre-slp

Alright, let me check this one too, thanks for reporting @alexandre-slp

rsercano avatar Apr 01 '21 13:04 rsercano