Postgresql slow query fetch

saulojb · Post by **saulojb** » Wed 15 Apr 2015 14:03

Hello, I had been happy with the news of correction, but unfortunately continues with the low performace in6.1.3... and history really nothing appears on the fix ...

got a little better, but still with half the 4.1 performace ...

saulojb · Post by **saulojb** » Sat 18 Apr 2015 17:32

nothing ? ual ....

FCS · Post by **FCS** » Sun 19 Apr 2015 05:43

Hello,

My tests confirmed your tests.
I have not installed 6.1.3 version yet.
I'm waiting for an answer from DevArt like you.

Regards
Michal

azyk · Post by **azyk** » Mon 20 Apr 2015 12:11

We continue investigation of this behavior. We will notify you about the results as any are available.

FCS · Post by **FCS** » Thu 30 Apr 2015 08:53

Hello,

I have tested new version 6.1.3 on BDS 2006 and PostgreSQL 9.4.1

Local tests: 10 sec (6 sec on UniDac 4.16)
Network tests: 37 sec (19 sec on UniDac 4.16)

Previous tests:

Local 3 tests:
XE7+FireDac = 9-10 sec
XE2+UniDac 4.1.6 = 6 sec
XE2+UniDac 6.0.1 = 14 sec
XE7+UniDac 6.0.1 = 13-14 sec

Network (remote) 3 tests:
XE7+FireDac = 20-21 sec
XE2+UniDac 4.1.6 = 19 sec
XE2+UniDac 6.0.1 = 49-64 sec
XE7+UniDac 6.0.1 = 46-50 sec

I'm waiting for improving it.

Regards
Michal

robertoicardi · Post by **robertoicardi** » Mon 04 May 2015 10:01

Hello,

someone tested if this behaviour does affect recent versions of plain simple pgdac too?

azyk · Post by **azyk** » Wed 06 May 2015 08:03

We have fixed this behavior. This fix will be included in the next UniDAC/PgDAC builds.

saulojb · Post by **saulojb** » Wed 06 May 2015 14:03

Great, I'm looking forward to test ...

thanks for reply

FCS · Post by **FCS** » Thu 07 May 2015 08:12

Hello,

Maybe version 6.1.4 this week ?

Regards
Michal

azyk · Post by **azyk** » Tue 12 May 2015 09:20

The UniDAC release is planned for within a month. If you want to get this fix before the next UniDAC version is released, please provide your license number to andreyz*devart*com and we will send you a night build.

FCS · Post by **FCS** » Sat 08 Aug 2015 09:57

Hello,

I have tested the new version 6.1.6 on BDS 2006 and PostgreSQL 9.4.1

Local tests: 6 sec (6 sec on UniDac 4.16)
Network tests: 19 sec (19 sec on UniDac 4.16)

Previous tests:

Local 3 tests:
XE7+FireDac = 9-10 sec
XE2+UniDac 4.1.6 = 6 sec
XE2+UniDac 6.0.1 = 14 sec
XE7+UniDac 6.0.1 = 13-14 sec
BDS2006+UniDac 6.1.3 = 10 sec

Network (remote) 3 tests:
XE7+FireDac = 20-21 sec
XE2+UniDac 4.1.6 = 19 sec
XE2+UniDac 6.0.1 = 49-64 sec
XE7+UniDac 6.0.1 = 46-50 sec
BDS2006+UniDac 6.1.3 = 37 sec

The current version is corrected and improved. Good job. Thanks.

Regards
Michal

azyk · Post by **azyk** » Tue 11 Aug 2015 11:45

It is good to see that the problem has been solved. Feel free to contact us if you have any further questions about UniDAC.

swierzbicki · Post by **swierzbicki** » Tue 11 Aug 2015 16:10

Thank you for the fix.

Devart Forums

Postgresql slow query fetch

Re: Postgresql slow query fetch

Re: Postgresql slow query fetch

Re: Postgresql slow query fetch

Re: Postgresql slow query fetch

Re: Postgresql slow query fetch

Re: Postgresql slow query fetch

Re: Postgresql slow query fetch

Re: Postgresql slow query fetch

Re: Postgresql slow query fetch

Re: Postgresql slow query fetch

Re: Postgresql slow query fetch

Re: Postgresql slow query fetch

Re: Postgresql slow query fetch