[postgis-users] MySQL-PostGIS performance comparison

[Paul DuBois]

> 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).

Do you mean MySQL is 10 times faster, or 10 times slower?

> 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.

MySQL has both non-transactional and transactional tables.  However,
currently the spatial data types are supported only for the MyISAM
storage engine, which handles non-transactional tables.