[OSM-dev] about Carto and SQL

[sav123]

-----Message d'origine----- 
From: Paul Norman
Sent: Tuesday, March 20, 2018 9:51 PM
To: dev at openstreetmap.org
Subject: Re: [OSM-dev] about Carto and SQL








On 3/20/2018 1:40 PM, sav123 wrote:
Kompza covered the variables you mentioned, but I if you're looking at
benchmarking, I recommend you set up the full rendering stack rather
than trying to generate queries yourself. The latter can be tricky to
get right, and you have to handle parallelism the same as the full stack
to get meaningful results. It's just easier to use renderd and feed it a
list of tiles with render_list than to write code that will take that
list, generate SQL, and run it.

This doesn't answer the question.
If you read the carto file, you will see that there are natural criteria , 
not only geometry.
Indeed, it is a bad idea to partition on coordinates, unless if a request 
applies to a small region.

>>I'm not speaking of partitioning, but of how to best benchmark 
>>performance, which is what you're planning to do to see if partitioning is 
>>worthwhile.

You don't know me but I see that you have your own idea. It's pretty amazing 
...

Please respect the protocol.
I ask and wait answers.
If it is a bad question, give argument on the question, not on me, we had 
not be presented.
Or else I have a lot of work, don't spend my time.








_______________________________________________
dev mailing list
dev at openstreetmap.org
https://lists.openstreetmap.org/listinfo/dev