From: | Thomas Chabaud <tc(at)geosys(dot)com> |
---|---|
To: | pgsql-odbc(at)postgresql(dot)org |
Subject: | Re: Slow query over ADSL Line |
Date: | 2006-03-06 10:54:10 |
Message-ID: | 440C14D2.8020106@geosys.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
Adnan DURSUN a écrit :
> ----- Original Message -----
>> From: "Thomas Chabaud" <tc(at)geosys(dot)com>
>> To: <pgsql-odbc(at)postgresql(dot)org>
>> Sent: Monday, March 06, 2006 12:20 PM
>> Subject: [ODBC] Slow query over ADSL Line
>
>
>>> Hello,
>>>
>>> I'm using psql ODBC driver with ADO in a visual basic 6 application,
>>> and I have some speed issues when I connect using an adsl line (8M
>>> down/1M up) (it works perfectly well using an ethernet 100Mbps LAN).
>>>
>>> The application sends about 300 queries to server, and it takes 150
>>> seconds to fetch the results of all queries. I have also tested some
>>> of the queries with pgAdmin, and it takes about 1.5s/2s for each query.
>>>
>>> The queries are all in the same simple form : "select
>>> myfield1,myfield2,myfield3[...] from table where id=myid",
>>> and they send back only 40/50 rows max.
>
> You must consider how amount of data your application gets from server !
>
> Adnan DURSUN
> ASRIN Bilisim Ltd.
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org
>
>
The total amount of data fetched from the server is approximately 500 ko.
From | Date | Subject | |
---|---|---|---|
Next Message | Adnan DURSUN | 2006-03-06 11:03:05 | Re: Slow query over ADSL Line |
Previous Message | Adnan DURSUN | 2006-03-06 10:48:23 | Re: Slow query over ADSL Line |