[GRASS-dev] better mysql support

[Paolo Cavallini]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

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

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.
> pc
> 
> Emanuele Conti ha scritto:
> 
>> mysql, which has geometry extensions (opengis compliant) and performs
>> significantly better than postgres.
- --
Paolo Cavallini
http://www.faunalia.it/pc
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFGI1jf/NedwLUzIr4RAoanAJ9ntwL5nHqK0TnLfKodnJ/HEPKYEQCdEyPI
Ved//u4ii0YaJEmca9I+fDM=
=u+0w
-----END PGP SIGNATURE-----