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 :
> m == mmoncure@gmail.com writes:
>
>  m> On Tue, Oct 21, 2008 at 9:07 AM, Brandon Metcalf  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@postgresql.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.