Lists: | pgsql-odbc |
---|
From: | "Philippe Lang" <philippe(dot)lang(at)attiksystem(dot)ch> |
---|---|
To: | <pgsql-odbc(at)postgresql(dot)org> |
Subject: | Re: TCP_NO_DELAY & TcpAckFrequency (Re: Slow query through ODBC) |
Date: | 2006-08-01 17:58:33 |
Message-ID: | 6C0CF58A187DA5479245E0830AF84F421D0FD6@poweredge.attiksystem.ch |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-odbc |
Arnaud Lesauvage wrote:
> Philippe Lang a écrit :
>> What client exactly do you use for querying the server in
> VBA? Are you maybe using MS Access? If yes, what version of
> Access are you using? 2003? And are you using an Access 2000
> compatible MDB maybe?
>> Otherwise, what client data access package are you using from VBA?
>> DAO? ADO?
>
>
> Philippe, the client is an Autocad2000 VBA macro.
> I am using ADO, with a DSN-less connection (basic connection
> string, nothing but server address, port, username and password).
>
> Do you have a clue ?
>
> Regards
Hi,
I suggest you try another client, like for example MS Access 2003 with a 2003 MDB, for example, just to make sure the problems comes from the driver. What you experience might be a problem that come from Autocad...
Can you make a test with DAO as well? Quite old, but might be faster as well...
---------------
Philippe Lang
Attik System
From: | Arnaud Lesauvage <thewild(at)freesurf(dot)fr> |
---|---|
To: | Philippe Lang <philippe(dot)lang(at)attiksystem(dot)ch> |
Cc: | pgsql-odbc(at)postgresql(dot)org |
Subject: | Re: TCP_NO_DELAY & TcpAckFrequency (Re: Slow query through |
Date: | 2006-08-01 20:37:34 |
Message-ID: | 44CFBB8E.6000303@freesurf.fr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-odbc |
Philippe Lang a écrit :
> I suggest you try another client, like for example MS Access 2003 with a 2003 MDB, for example, just to make sure the problems comes from the driver. What you experience might be a problem that come from Autocad...
>
> Can you make a test with DAO as well? Quite old, but might be faster as well...
I can try from within Access2000, but I don't have Access2003.
I'll try DAO as well.
Thanks for your suggestions !
--
Arnaud
From: | Arnaud Lesauvage <thewild(at)freesurf(dot)fr> |
---|---|
To: | thewild(at)free(dot)fr |
Cc: | Philippe Lang <philippe(dot)lang(at)attiksystem(dot)ch>, pgsql-odbc(at)postgresql(dot)org |
Subject: | Re: TCP_NO_DELAY & TcpAckFrequency (Re: Slow query through |
Date: | 2006-08-02 07:30:41 |
Message-ID: | 44D054A1.1020101@freesurf.fr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-odbc |
Arnaud Lesauvage wrote:
> Philippe Lang a écrit :
>> I suggest you try another client, like for example MS Access 2003 with a 2003 MDB, for example, just to make sure the problems comes from the driver. What you experience might be a problem that come from Autocad...
>>
>> Can you make a test with DAO as well? Quite old, but might be faster as well...
>
> I can try from within Access2000, but I don't have Access2003.
> I'll try DAO as well.
I found the problem !
I just used UseDeclareFetch=1 in the connection string, and now my
queries are blindingly fast !!!
I am quite amazed, I am pretty sure I tried this before... I even
thin I removed this setting when trying to find the cause of the
problemm !...
Thanks a lot to all the people who helped me !
Regards
--
Arnaud