Re: python daemon - compress data and load data into MySQL by pyodbc

2009-09-04 Thread MacRules
Dennis Lee Bieber wrote: On Thu, 03 Sep 2009 14:43:40 -0400, MacRules declaimed the following in gmane.comp.python.general: Oracle DB in data center 1 (LA, west coast) MSSQL DB in data center 2 (DC, east coast) Note that your thread subject line states MySQL... There is a big differe

Re: python daemon - compress data and load data into MySQL by pyodbc

2009-09-03 Thread Ben Finney
MacRules writes: > What I am looking for is this. > > Oracle DB in data center 1 (LA, west coast) > MSSQL DB in data center 2 (DC, east coast) > So network bandwidth is an issue Okay, that's a brief description but is clearer than we had before. > I prefer to have gzip fist and > deliver the da

Re: python daemon - compress data and load data into MySQL by pyodbc

2009-09-03 Thread MacRules
Martin P. Hellwig wrote: MacRules wrote: What I am looking for is this. Oracle DB in data center 1 (LA, west coast) MSSQL DB in data center 2 (DC, east coast) So network bandwidth is an issue, I prefer to have gzip fist and deliver the data. If bandwidth is really an issue, you should send

Re: python daemon - compress data and load data into MySQL by pyodbc

2009-09-03 Thread Martin P. Hellwig
MacRules wrote: What I am looking for is this. Oracle DB in data center 1 (LA, west coast) MSSQL DB in data center 2 (DC, east coast) So network bandwidth is an issue, I prefer to have gzip fist and deliver the data. If bandwidth is really an issue, you should send compressed delta's. I n

Re: python daemon - compress data and load data into MySQL by pyodbc

2009-09-03 Thread MacRules
Ben Finney wrote: MacRules writes: Are you a Python expert? This group has many Python experts, and even more people who can no doubt help you if you are able to articulate what you need help with. To help dispel a possible misunderstanding: Don't expect to have a one-on-one conversation wi

Re: python daemon - compress data and load data into MySQL by pyodbc

2009-09-03 Thread Ben Finney
MacRules writes: > Are you a Python expert? This group has many Python experts, and even more people who can no doubt help you if you are able to articulate what you need help with. To help dispel a possible misunderstanding: Don't expect to have a one-on-one conversation with a single devoted

Re: python daemon - compress data and load data into MySQL by pyodbc

2009-09-03 Thread David Smith
MacRules wrote: > Sean DiZazzo wrote: >> On Sep 2, 8:36 pm, MacRules wrote: >>> Hi, >>> >>> I installed Python daemon, pyodbc module to access the back-end DB >>> server. >>> >>> My setup is like this >>> >>> load data job -> Python Daemon A, port 6000 -> Python Daemon B, port >>> 7000 -> MySQL >>

Re: python daemon - compress data and load data into MySQL by pyodbc

2009-09-03 Thread MacRules
Sean DiZazzo wrote: On Sep 2, 8:36 pm, MacRules wrote: Hi, I installed Python daemon, pyodbc module to access the back-end DB server. My setup is like this load data job -> Python Daemon A, port 6000 -> Python Daemon B, port 7000 -> MySQL Daemon A will perform data compression, such as GZIP

Re: python daemon - compress data and load data into MySQL by pyodbc

2009-09-02 Thread Sean DiZazzo
On Sep 2, 8:36 pm, MacRules wrote: > Hi, > > I installed Python daemon, pyodbc module to access the back-end DB server. > > My setup is like this > > load data job -> Python Daemon A, port 6000 -> Python Daemon B, port > 7000 -> MySQL > > Daemon A will perform data compression, such as GZIP, and s

python daemon - compress data and load data into MySQL by pyodbc

2009-09-02 Thread MacRules
Hi, I installed Python daemon, pyodbc module to access the back-end DB server. My setup is like this load data job -> Python Daemon A, port 6000 -> Python Daemon B, port 7000 -> MySQL Daemon A will perform data compression, such as GZIP, and send over data to Daemon B. Daemon B will perform