From: | "Adnan DURSUN" <a_dursun(at)hotmail(dot)com> |
---|---|
To: | <tc(at)geosys(dot)com>, <pgsql-odbc(at)postgresql(dot)org> |
Subject: | Re: Slow query over ADSL Line |
Date: | 2006-03-06 10:48:23 |
Message-ID: | BAY106-DAV3649CB4F8C5087B5FA563FAE90@phx.gbl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
----- 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.
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas Chabaud | 2006-03-06 10:54:10 | Re: Slow query over ADSL Line |
Previous Message | Thomas Chabaud | 2006-03-06 10:20:10 | Slow query over ADSL Line |