Re: Data transfer very slow when connected via DSL
От
Harald Armin Massa
Тема
Re: Data transfer very slow when connected via DSL
Дата
Msg-id
7be3f35d0706220324n1b8a41e1q7d235970044da689@mail.gmail.com
Ответ на
Re: Data transfer very slow when connected via DSL (Rainer Bauer)
Список
Дерево обсуждения
Re: Data transfer very slow when connected via DSL Rainer Bauer <usenet@munnin.com>
Re: Data transfer very slow when connected via DSL "Joshua D. Drake" <jd@commandprompt.com>
Rainer,
Correct. I use a pyro-remote server. On request this remote server copies the relevant rows into a temporary table, uses a copy_to Call to push them into a StringIO-Objekt (that's Pythons version of "In Memory File"), serializes that StringIO-Objekt, does a bz2-compression and transfers the whole block via VPN.
I read on in this thread, and I scheduled to check on psycopg2 and what it is doing with cursors.
Harald
--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Spielberger Straße 49
70435 Stuttgart
0173/9409607
fx 01212-5-13695179
-
EuroPython 2007 will take place in Vilnius, Lithuania from Monday 9th July to Wednesday 11th July. See you there!
>I did not find a solution so far; and for bulk data transfers I now
>programmed a workaround.
But that is surely based on some component installed on the server, isn't it?
Correct. I use a pyro-remote server. On request this remote server copies the relevant rows into a temporary table, uses a copy_to Call to push them into a StringIO-Objekt (that's Pythons version of "In Memory File"), serializes that StringIO-Objekt, does a bz2-compression and transfers the whole block via VPN.
I read on in this thread, and I scheduled to check on psycopg2 and what it is doing with cursors.
Harald
--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Spielberger Straße 49
70435 Stuttgart
0173/9409607
fx 01212-5-13695179
-
EuroPython 2007 will take place in Vilnius, Lithuania from Monday 9th July to Wednesday 11th July. See you there!
В списке pgsql-performance по дате отправления
