[GRASS-dev] better mysql support
cavallini at faunalia.it
Mon Apr 16 07:07:11 EDT 2007
-----BEGIN PGP SIGNED MESSAGE-----
This should be related to mysql being non-ACID, something we often
cannot afford in GIS.
Performance != speed, especially in geographic contexts. PostGIS is far
more powerful than the MySQL spatial.
All the best.
Emanuele Conti ha scritto:
> Something can be read from google and so on, but personally I did
> benchmarks based on performances and mysql server prerforms
> significantly better in most of circumstances; I did experiments using
> also ram-fs to store data for both of them, but the all-in-memory engine
> of mysql is the fastest and better optimized of the possibilities
> (always in terms of performances), followed by myisam engine with or
> without ram-fs; at last comes postgres...
> 2007/4/16, Paolo Cavallini <cavallini at faunalia.it
> <mailto:cavallini at faunalia.it>>:
> do you have data supporting this statement?
> from my experience this is not true.
> Emanuele Conti ha scritto:
>> mysql, which has geometry extensions (opengis compliant) and performs
>> significantly better than postgres.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
-----END PGP SIGNATURE-----
More information about the grass-dev