[postgis-users] MySQL-PostGIS performance comparison

christopher.faulkner at ntlworld.com christopher.faulkner at ntlworld.com
Fri Mar 5 02:58:28 PST 2004


Did you try my suggestion ? Remove the astext() function. I had the same problem but it wasn't the SELECTION/query that was slow, just the function operating on the results.

Chris

> 
> From: "Alvaro Zabala" <alvaro_zabala at hotmail.com>
> Date: 2004/03/05 Fri AM 10:56:24 GMT
> To: postgis-users at postgis.refractions.net
> Subject: [postgis-users] MySQL-PostGIS performance comparison
> 
> Some days ago I wrote a mail to this list about performance of some spatial 
> querys.
> These querys are made from a PlugIn of JUMP (Java Unified Mapping Platform) 
> which we are developing.
> 
> We have developed a similar plugin to access MySQL. SQL Code (built 
> dynamically from FeatureCollection schema) is similar, because PostGIS and 
> MySQL are implementations of OGC Standars.
> 
> Ive noticed that MySQL performance for querys is about 10:1 compare to the 
> same querys with PostGIS. My two tables (MySQL and Postgis) have spatial 
> indexes, and PostGIS's table has been vacuum).
> 
> Are this results normal? Do you want original data to make some performance 
> tests?
> Alse Ive read in Internet that MySQL is very fast (even more fast than 
> Oracle) because it isn't a transactional DB -people say it hasnt integrity). 
> Has Postgre this integrity in transactional environments?
> I dont want to disturb you. I only want to help you to improve Postgis.
> 
> Regars
> 
> _________________________________________________________________
> STOP MORE SPAM with the new MSN 8 and get 2 months FREE* 
> http://join.msn.com/?page=features/junkmail
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> 

-----------------------------------------
Email provided by http://www.ntlhome.com/





More information about the postgis-users mailing list