Hi Walter When you connect to the PostGis database make sure that you have selected the "Use estimated metadata" option - this optimises the connection for large datasets - see attached screenshot. This should greatly improve the connection times for postigs. (If you are already doing this then may need to look further!)
Cheers Chris ________________________________________ From: walter.nordmann [[email protected]] Sent: 10 October 2014 02:29 To: [email protected] Subject: Re: [Qgis-developer] Trouble with PostGis plugin sorry, no special plugin; just that build in PostGis tool. mainly i need to the the queries going to the server in order to optimize some indexes. even adding EXPLAIn to the Query whould help a lot. regards walter -- View this message in context: http://osgeo-org.1560.x6.nabble.com/Trouble-with-PostGis-plugin-tp5166669p5166687.html Sent from the Quantum GIS - Developer mailing list archive at Nabble.com. This message contains information, which may be in confidence and may be subject to legal privilege. If you are not the intended recipient, you must not peruse, use, disseminate, distribute or copy this message. If you have received this message in error, please notify us immediately (Phone 0800 665 463 or [email protected]) and destroy the original message. LINZ accepts no responsibility for changes to this email, or for any attachments, after its transmission from LINZ. Thank You.
_______________________________________________ Qgis-developer mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/qgis-developer
