-
Notifications
You must be signed in to change notification settings - Fork 21
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
number of database queries #4
Comments
For the For the |
I might have found a way querying the database only once by using a grid calculated by a postgis function: |
query amount reduced using temporary tables |
Good job. I can't test because i am on travels but good job. |
There is a significant performance hit for making SELECT for each cell in
gridCluster
andkmeansCluster
. Have you thought about reducing it to just one (or a few) queries? I am not completely sure that it is possible but I feel it should be and it would improve performance greatly (especially if you have lots of cells). Have you thought about it? I am looking for a way to do it but I would like to hear from you first what you think.The text was updated successfully, but these errors were encountered: