[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Health-dev] Change the database postgreSQL
From: |
Cédric Krier |
Subject: |
Re: [Health-dev] Change the database postgreSQL |
Date: |
Sun, 29 Jul 2012 16:01:42 +0200 |
User-agent: |
Mutt/1.5.21 (2010-09-15) |
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