is there a limit for the number of point a visualisation can render?

[adr...@tileo.co]

Hi, in a localhost setup of Carto with a dataset that includes over 250k points the visualisation isn't displaying them all (see screenshots). Is there a config file that sets a max for this? In that case, where do I change it? I checked the same dataset on carto.com and it works just perfect.

Thanks!

[Jorge Sanz]

are you checking your logs? maybe you are hitting database timeouts?

On Thu, Apr 6, 2017 at 11:59 AM, <adr...@tileo.co> wrote:

Hi, in a localhost setup of Carto with a dataset that includes over 250k points the visualisation isn't displaying them all (see screenshots). Is there a config file that sets a max for this? In that case, where do I change it? I checked the same dataset on carto.com and it works just perfect.

Thanks!

--

---
You received this message because you are subscribed to the Google Groups "cartodb" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cartodb+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

Jorge Sanz

Solutions Engineer & Support Manager

CARTO - Predict through location

Come to CARTO LOCATIONS - Madrid - April 26/27

Tickets and +info at https://carto.com/locations-event

[adr...@tileo.co]

Hi, not a timeout but i can see this messages:

postgis       | WARNING:  CDB_QueryTables cannot explain query: select * from cdb_dataservices_client.cdb_service_quota_info() (3F000: schema "cdb_dataservices_client" does not exist)

postgis       | CONTEXT:  PL/pgSQL function cdb_querytablestext(text) line 23 at RAISE

postgis       | SQL function "cdb_querytables_updated_at" statement 1

postgis       | ERROR:  schema "cdb_dataservices_client" does not exist

postgis       | CONTEXT:  PL/pgSQL function cdb_querytablestext(text) line 24 at RAISE

postgis       | SQL function "cdb_querytables_updated_at" statement 1

postgis       | STATEMENT:  SELECT * FROM CDB_QueryTables_Updated_At($windshaft$select * from cdb_dataservices_client.cdb_service_quota_info();$windshaft$)

postgis       | ERROR:  schema "cdb_dataservices_client" does not exist at character 15

postgis       | STATEMENT:  select * from cdb_dataservices_client.cdb_service_quota_info()

Not sure if related, though

Thanks!

On Thursday, April 6, 2017 at 9:38:40 PM UTC+2, Jorge Sanz wrote:

are you checking your logs? maybe you are hitting database timeouts?

On Thu, Apr 6, 2017 at 11:59 AM, <adr...@tileo.co> wrote:

Hi, in a localhost setup of Carto with a dataset that includes over 250k points the visualisation isn't displaying them all (see screenshots). Is there a config file that sets a max for this? In that case, where do I change it? I checked the same dataset on carto.com and it works just perfect.

Thanks!

--

---
You received this message because you are subscribed to the Google Groups "cartodb" group.

To unsubscribe from this group and stop receiving emails from it, send an email to cartodb+u...@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

[Juanjo Mata]

In case people come back searching for the answer ... we figured it out (it was a silly one, really: Windshaft's limit was stuck still at the "development" level):

// max number of rows to return when querying data, 0 means no limit 

row_limit: 65535,

... so made it 0:

row_limit: 0,

Thanks!

[Mario de Frutos Dieguez]

To get rid of that errors you should install the Dataservices-API extension