|
$sql = "SELECT * FROM settings.geometry_columns_view WHERE _key_ LIKE :schema"; |
we have currently changes to this instead:
$sql = "SELECT privileges FROM settings.geometry_columns_join WHERE _key_ = :schema"; which cuts the query time dramatically.
our working theory is, that the view is slowed down when accessing sourced that were define ie. as FT. the code block only uses privileges field. before this, we successfully sped up the query by setting random_page_cost to 1 (from default 4), to make sure indexes were used.
geocloud2/app/inc/http_basic_authen.php
Line 64 in 75d2aec
we have currently changes to this instead:
$sql = "SELECT privileges FROM settings.geometry_columns_join WHERE _key_ = :schema";which cuts the query time dramatically.our working theory is, that the view is slowed down when accessing sourced that were define ie. as FT. the code block only uses privileges field. before this, we successfully sped up the query by setting
random_page_costto 1 (from default 4), to make sure indexes were used.