Re: syncing with a MySQL DB

I use dbi-link, work fine, but I have problems when I call mysql
tables "linked" and these tables are big, maybe a millon records, the
answers is really slow, I need to wait 5 or more minutes to have an
answer in a single query like this "select * from table limit 10", I
am thinking maybe dbi-link download all the data to pgsql before to
give me the answer.

Anybody knows how improve this?

thnaks

2008/10/21 Brandon Metcalf <bmetcalf(at)nortel(dot)com>:
> m == mmoncure(at)gmail(dot)com writes:
>
> m> On Tue, Oct 21, 2008 at 9:07 AM, Brandon Metcalf <bmetcalf(at)nortel(dot)com> wrote:
> m> > I have a need to keep a PostgreSQL and MySQL table synchronized. My
> m> > thoughts are to use triggers on the pgsql side to manipulate the MySQL
> m> > table when data in the pgsql table is changed. I also plan on using
> m> > PL/Perl to write the functions.
> m> >
> m> > Are there better ways to achieve this?
>
> m> have you looked at dbi-link?
>
>
> No, but just did and it looks very cool. Have you used it before? If
> so, would you mind if I ask you some questions? We could take it off
> the list if that's more appropriate.
>
> --
> Brandon
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

--
Inscribete en las listas de APESOL
http://www.apesol.org/listas.php

Visita
http://www.eqsoft.net
Manuales, noticias, foros, etc.