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 <usenet@munnin.com>)
Ответы Re: Data transfer very slow when connected via DSL  (PFC <lists@peufeu.com>)
Список pgsql-performance
Rainer,

>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 по дате отправления:

Предыдущее
От: Dave Page
Дата:
Сообщение: Re: Data transfer very slow when connected via DSL
Следующее
От: PFC
Дата:
Сообщение: Re: Data transfer very slow when connected via DSL