Speed-up query by decreasing duration time

161
October 26, 2018, at 8:40 PM

I use pg-promise to query a postgis database containing rasters. Queries are strings (with no parameters) generated before being processed by pg-promise.

The duration time of one query is typically 140ms (given by result function), while only 15ms in psql.

Example:

SELECT ST_Value(t_2m_1, ST_SetSrid(ST_MakePoint(5,50),4326)) AS t_2m_1 FROM iconeu_001 WHERE ST_Intersects(t_2m_1,ST_SetSrid(ST_MakePoint(5,50),4326));
Results: [ { t_2m_1: 4.61391601562502 } ] Duration: 147ms

While timing in psql:

      t_2m_1
------------------
 4.61391601562502
(1 row)
Time: 15.828 ms

It means that 90% of time is spent by pre and post processing the query as explained here.

Also, is there any way of dramatically speed up this steps (by skipping some unneeded steps for instance) ??

Thanks in advance.

PS: congratulations to vitaly-t for this excellent module !

Rent Charter Buses Company
READ ALSO
How to check chromium browser is opened or not using Puppeteer?

How to check chromium browser is opened or not using Puppeteer?

I need to check using puppeteer browser is opened or notIf It is not opened then it should open

150
Promise sends resolve before the process finish

Promise sends resolve before the process finish

everybody, I have a project, that asks user to where their target URL for download images and compress themAfter I ask user URL, the process downloads images into a directory one by one asynchronously but, after all files download i send resolve in this Promise

147
JQuery callback works intermittently

JQuery callback works intermittently

Please I am having a problem with a flask based app running on gunicorn using nginx as a proxyA JQuery callback of mine works intermittently

133
animation html code in canvas not running

animation html code in canvas not running

i have written the code below to run in html5 but it does not seem to be workingthe code below is suppose to run when a user clicks on the canvas

136