<html><head></head><body><div style="color:#000; background-color:#fff; font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:16px"><div id="yui_3_16_0_ym19_1_1463725659391_8183">Well this is not a looking for help post.</div><div id="yui_3_16_0_ym19_1_1463725659391_8185">I just want to marvel at the speed of postgis database.</div><div dir="ltr" id="yui_3_16_0_ym19_1_1463725659391_8187">I have been working on a BI (Business Intelligence) project broadcasting gigabytes of spatial thematic data over the internet.</div><div id="yui_3_16_0_ym19_1_1463725659391_8196">QGIS server along is part of the answer, qgis2map is a life-savior. the problem is the speed of access datasets in the shapefile format. <br></div><div id="yui_3_16_0_ym19_1_1463725659391_8198" dir="ltr">Now，when i switch to postgis as the data source, the speed is LIGHTENING fast!</div><div id="yui_3_16_0_ym19_1_1463725659391_8200" dir="ltr"><br></div><div id="yui_3_16_0_ym19_1_1463725659391_8202" dir="ltr">So what I am seeing is that this workflow can be a valuable part of the BI system of most corporations in the world.</div><div id="yui_3_16_0_ym19_1_1463725659391_8225" dir="ltr"><br></div><div id="yui_3_16_0_ym19_1_1463725659391_8246" dir="ltr">Raw data is stored in Hive on the cloud, fetched by Spark ad processed in python, whose results are then fed to a postgis database. The thematic layers in postgis database are collected by QGIS server and broadcast out as WMS. Then, an apache server displays the frontend map with openlayers(batch generated by qgis2map).</div><div id="yui_3_16_0_ym19_1_1463725659391_8289" dir="ltr"><br></div><div id="yui_3_16_0_ym19_1_1463725659391_8299" dir="ltr">speed, data security, spatial information embedded into big data infrastructure. <br></div><div id="yui_3_16_0_ym19_1_1463725659391_8330" dir="ltr">simply wow<br></div><div id="yui_3_16_0_ym19_1_1463725659391_8211"><br></div></div></body></html>