Re: [Health-dev] Change the database postgreSQL

[Cédric Krier]

On 26/07/12 13:18 -0500, zodman wrote:
> which it is the reason for running with mysql ?
> 
> tryton core of gnuhealth it is designed to posgresql.
> 
> mysql have this problems
> https://groups.google.com/forum/#!msg/tryton-dev/bNYEvOh-ZrA/MEAjGrJPV90J

And more over MySQL is really *slower*.
The unittest runs in about 1 hour for PostgreSQL and SQLite.
But for MySQL (on the same host), it takes about 5 hours.

Any way, if you want any way go, you should probably write a script to
migrate data. You can find an example sqlite2pg [1] but your will be
much more complex because MySQL fails on many SQL standard.

[1] http://hg.tryton.org/tryton-tools/file/bec1fddd9996/sqlite2pg.py

-- 
Cédric Krier

B2CK SPRL
Rue de Rotterdam, 4
4000 Liège
Belgium
Tel: +32 472 54 46 59
Email/Jabber: address@hidden
Website: http://www.b2ck.com/

pgpFl8gJXR6mP.pgp
Description: PGP signature