Thread: speed issue
Hi
I am using the Postgres ODBC driver ( lastest version that I recently downloaded )
I am using this via a SQL server linked server ( SQL Server 2008r2 ), running on 64bit Windows Server
The connection works fine, but I find that queries are very slow to execute – even simple queries ( select * from [small_table] )
Using PGAdmin III the same queries will run in a couple of seconds or less.
Any ideas why I experience this slow response time ?
Regards,
Kevin Dockerty
Head of Development
Worcestershire Acute Hospital NHS Trust
2nd Floor, No. 3 King’s Court, Worcestershire Royal Hospital, WR51DD
Tel: 01905 763333 (ext 38567)
k.dockerty@nhs.net
********************************************************************************************************************
This message may contain confidential information. If you are not the intended recipient please inform the
sender that you have received the message in error before deleting it.
Please do not disclose, copy or distribute information in this e-mail or take any action in reliance on its contents:
to do so is strictly prohibited and may be unlawful.
Thank you for your co-operation.
NHSmail is the secure email and directory service available for all NHS staff in England and Scotland
NHSmail is approved for exchanging patient data and other sensitive information with NHSmail and GSi recipients
NHSmail provides an email address for your career in the NHS and can be accessed anywhere
For more information and to find out how you can switch, visit www.nhsdigital.nhs.uk/nhsmail
********************************************************************************************************************
On 08/29/2016 03:15 AM, Dockerty Kevin (WORCESTERSHIRE ACUTE HOSPITALS NHS TRUST) wrote: > Hi > > > > I am using the Postgres ODBC driver ( lastest version that I recently > downloaded ) Probably does not matter in this case, but the actual version number would be helpful. Mainly because latest is a point in time thing and if the problem does turn out to be version related issue then it would be helpful to those that run across this thread in the future to know what version is being discussed. > > > > I am using this via a SQL server linked server ( SQL Server 2008r2 ), > running on 64bit Windows Server Can you elaborate more on what the actual setup is? In particular the ODBC driver settings. > > > > The connection works fine, but I find that queries are very slow to > execute – even simple queries ( select * from [small_table] ) > > > > Using PGAdmin III the same queries will run in a couple of seconds or less. Are you running PGAdmin from the same machine as the SQL server? In other words is there a difference in the network path between the two programs? > > > > Any ideas why I experience this slow response time ? Is there anything in the Postgres logs that might help? > > > > Regards, > > > > > > *Kevin Dockerty* > > *Head of Development** > *Worcestershire Acute Hospital NHS Trust > > 2^nd Floor, No. 3 King’s Court, Worcestershire Royal Hospital, WR51DD > > > > Tel: 01905 763333 (ext 38567) > > *k.dockerty@nhs.net * > > www.worcsacute.nhs.uk <http://www.worcsacute.nhs.uk/> > > > > > > ******************************************************************************************************************** > > This message may contain confidential information. If you are not the > intended recipient please inform the > sender that you have received the message in error before deleting it. > Please do not disclose, copy or distribute information in this e-mail or > take any action in reliance on its contents: > to do so is strictly prohibited and may be unlawful. > > Thank you for your co-operation. > > NHSmail is the secure email and directory service available for all NHS > staff in England and Scotland > NHSmail is approved for exchanging patient data and other sensitive > information with NHSmail and GSi recipients > NHSmail provides an email address for your career in the NHS and can be > accessed anywhere > For more information and to find out how you can switch, visit > www.nhsdigital.nhs.uk/nhsmail > > ******************************************************************************************************************** -- Adrian Klaver adrian.klaver@aklaver.com
From: pgsql-odbc-owner@postgresql.org [mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of Dockerty Kevin (WORCESTERSHIRE ACUTE HOSPITALS NHS TRUST)
I am using this via a SQL server linked server ( SQL Server 2008r2 ), running on 64bit Windows Server
The connection works fine, but I find that queries are very slow to execute – even simple queries ( select * from [small_table] )
Using PGAdmin III the same queries will run in a couple of seconds or less.
In addition to Adrian’s questions, how slow? Does it take more than 10 seconds?
Why don’t you try ODBC Trace in the ODBC Data Source Administrator? It saves the name and duration of each ODBC API call in a text file.
Regards
Takayuki Tsunakawa
On 08/31/2016 03:57 AM, Dockerty Kevin (WORCESTERSHIRE ACUTE HOSPITALS NHS TRUST) wrote: Please respond to list also. Ccing list. > > Version is 09 05 03 > > I have tried using OPEN QUERY in SQL Server and it now works fine :-) > > > Kevin Dockerty > Head of Development > Worcestershire Acute Hospital NHS Trust > 2nd Floor, No. 3 King's Court, Worcestershire Royal Hospital, WR51DD > > Tel: 01905 763333 (ext 38567) > k.dockerty@nhs.net > www.worcsacute.nhs.uk > > > -----Original Message----- > From: Adrian Klaver [mailto:adrian.klaver@aklaver.com] > Sent: 29 August 2016 20:57 > To: Dockerty Kevin (WORCESTERSHIRE ACUTE HOSPITALS NHS TRUST); pgsql-odbc@postgresql.org > Subject: Re: [ODBC] speed issue > > On 08/29/2016 03:15 AM, Dockerty Kevin (WORCESTERSHIRE ACUTE HOSPITALS NHS TRUST) wrote: >> Hi >> >> >> >> I am using the Postgres ODBC driver ( lastest version that I recently >> downloaded ) > > Probably does not matter in this case, but the actual version number would be helpful. Mainly because latest is a pointin time thing and if the problem does turn out to be version related issue then it would be helpful to those that runacross this thread in the future to know what version is being discussed. > >> >> >> >> I am using this via a SQL server linked server ( SQL Server 2008r2 ), >> running on 64bit Windows Server > > Can you elaborate more on what the actual setup is? > > In particular the ODBC driver settings. > >> >> >> >> The connection works fine, but I find that queries are very slow to >> execute - even simple queries ( select * from [small_table] ) >> >> >> >> Using PGAdmin III the same queries will run in a couple of seconds or less. > > Are you running PGAdmin from the same machine as the SQL server? > > In other words is there a difference in the network path between the two programs? > >> >> >> >> Any ideas why I experience this slow response time ? > > Is there anything in the Postgres logs that might help? > >> >> >> >> Regards, >> >> >> >> >> >> *Kevin Dockerty* >> >> *Head of Development** >> *Worcestershire Acute Hospital NHS Trust >> >> 2^nd Floor, No. 3 King's Court, Worcestershire Royal Hospital, WR51DD >> >> >> >> Tel: 01905 763333 (ext 38567) >> >> *k.dockerty@nhs.net * >> >> www.worcsacute.nhs.uk <http://www.worcsacute.nhs.uk/> >> >> >> >> >> >> ********************************************************************** >> ********************************************** >> >> This message may contain confidential information. If you are not the >> intended recipient please inform the sender that you have received the >> message in error before deleting it. >> Please do not disclose, copy or distribute information in this e-mail >> or take any action in reliance on its contents: >> to do so is strictly prohibited and may be unlawful. >> >> Thank you for your co-operation. >> >> NHSmail is the secure email and directory service available for all >> NHS staff in England and Scotland NHSmail is approved for exchanging >> patient data and other sensitive information with NHSmail and GSi >> recipients NHSmail provides an email address for your career in the >> NHS and can be accessed anywhere For more information and to find out >> how you can switch, visit www.nhsdigital.nhs.uk/nhsmail >> >> ********************************************************************** >> ********************************************** > > > -- > Adrian Klaver > adrian.klaver@aklaver.com > > > ******************************************************************************************************************** > > This message may contain confidential information. If you are not the intended recipient please inform the > sender that you have received the message in error before deleting it. > Please do not disclose, copy or distribute information in this e-mail or take any action in reliance on its contents: > to do so is strictly prohibited and may be unlawful. > > Thank you for your co-operation. > > NHSmail is the secure email and directory service available for all NHS staff in England and Scotland > NHSmail is approved for exchanging patient data and other sensitive information with NHSmail and GSi recipients > NHSmail provides an email address for your career in the NHS and can be accessed anywhere > For more information and to find out how you can switch, visit www.nhsdigital.nhs.uk/nhsmail > > ******************************************************************************************************************** > -- Adrian Klaver adrian.klaver@aklaver.com