Re: IMPORTANT:migration de mysql =>postgresql

From: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
To: Radu-Adrian Popescu <radu(dot)popescu(at)aldratech(dot)com>
Cc: <hugo_rousse(at)club-internet(dot)fr>, <pgsql-admin(at)postgresql(dot)org>
Subject: Re: IMPORTANT:migration de mysql =>postgresql
Date: 2003-06-19 17:14:39
Message-ID: Pine.LNX.4.33.0306191113430.7760-100000@css120.ihs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Thu, 19 Jun 2003, Radu-Adrian Popescu wrote:

> >Sachant que quand je crée un rapport j'ai entre 100 et 600 requetes
>
> That sounds a bit strange; you mean the report comprises between 100 and
> 600 requests to the database ? Queries ?
> Then perhaps you should look into some other way of doing this, like query
> re-writing and combining, using an external program
> (say a perl script) that connects thru an unix socket (probably faster that
> tcp/ip, if that's the case), .... it depends.
> If those are rows, on the other hand, something is _really_ wrong.

He may well be doing something in MySQL that you can only do with 600
queries, that would be one big query in postgresql. That would be one of
the reasons I didn't choose mysql at the beginning was I needed to do
stuff that would have required way too many queries in MySQL.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Radu-Adrian Popescu 2003-06-19 17:20:08 Re: IMPORTANT:migration de mysql =>postgresql
Previous Message Radu-Adrian Popescu 2003-06-19 16:53:12 Re: IMPORTANT:migration de mysql =>postgresql