| From: | Thomas Chabaud <tc(at)geosys(dot)com> |
|---|---|
| To: | pgsql-odbc(at)postgresql(dot)org |
| Subject: | Slow query over ADSL Line |
| Date: | 2006-03-06 10:20:10 |
| Message-ID: | 440C0CDA.5010007@geosys.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-odbc |
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.
I have no debug option enabled, and there is no "blob" object in my database.
I use the following options with ADO recordset :
Dim rec as ADODB.Recordset
set rec=New ADODB.Recordset
rec.open myquery, myDbConn, adOpenStatic, adLockReadOnly, adCmdText
Does the slowness is due to ADO or ODBC ?
Is there a simple way to speed up the result fetch ?
Thanks in advance,
Regards
Thomas Chabaud
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adnan DURSUN | 2006-03-06 10:48:23 | Re: Slow query over ADSL Line |
| Previous Message | Daniel Holm | 2006-03-06 06:51:02 | Re: Problem connecting MS SQLServer & Postgresql using psqlODBC driver |