[postgis-users] MySQL-PostGIS performance comparison

Paul DuBois paul at kitebird.com
Fri Mar 5 09:33:10 PST 2004


On Fri, Mar 05, 2004 at 09:29:53AM -0800, David Blasby wrote:
> The performance evaluation I did of MySQL's spatial component showed 
> that MySQL was either significantly slower in some cases to slightly 
> faster in some.
> 
> These differences may have been due to how the disk cache was being used 
> (they were run on the same machine).
> 
> If were were to tell me MySQL's non-trasactional tables were 10-20% 
> faster than Postgresql's transactional table, I'd believe them.  But, I 
> dont believe its 1000% faster!
> 
> It sounds like there's something wrong with your query....
> 
> dave

One possibility might be MySQL's query cache, if any of the test
queries are executed repeatedly.  In this case, the result for a
cached query is returned directly from the cache without having
to be executed at all.  It may be helpful in this case to disable
the cache.



More information about the postgis-users mailing list