[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

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.


Cédric Krier

Rue de Rotterdam, 4
4000 Liège
Tel: +32 472 54 46 59
Email/Jabber: address@hidden

Attachment: pgpFl8gJXR6mP.pgp
Description: PGP signature

reply via email to

[Prev in Thread] Current Thread [Next in Thread]