Postgresql slow query fetch

[saulojb]

Hello,

I'm testing your product, and beyond the capacity multi database, it has interesting features that will be welcome if the company default on its technology, but something bothers me, Postgres only has direct access option. But this form of access, I'm having requests 3-4 times slower than the libraries of competitors using the native client.
An example in the direct comparison Firedac (sorry for sitar names) natively on XE7, performs a fetch (gigabit ethernet) 1000,000 records, with about 500MB in 8/2 (fetch all) and your product takes about 30 seconds. My question is. Iso is a restriction of trial version, or a problem of technology even in the final version?
And is there any intention of offering choice between direct connection and via customer to the Postgres as was done for Oracle?

Thank's
Saulo

[saulojb]

I cried a virtual machine, with delphi 2007 and unidac 4 series, and the result of a query with 1000000 records and 500 Mb is impresive 3 s. Is reality the best fetch possible ...
please corrige the version 6 ... certainly will be my choice !!!

Tanks

Saulo

[FCS]

Hello,

How many fields have you got in this table ?
Are there blob fields with big data ?

In my case, a query works slow if there are a lot of fields (more then 100).

Regards
Michal

[saulojb]

No not are many fields, are 30 fields, no blobs ...
In version 4, is very very fast, but in version 6 is very very slow ....


Tanks.

[FCS]

Did you try to use 4.xx on XE7 and 6.02 on BDS2007 ?

The XE7 use unicode but BDS not. Maybe here is the problem.

Regards
Michal

[azyk]

Please send a small sample of this performance test to andreyz*devart*com for investigation. In addition, include the scripts for creating the test tables.

[saulojb]

Ok i am providence, but are any FTP for post script ? The test are With large data table ...

[azyk]

The tables data itself is not needed. Include only scripts for creating tables structure.

[saulojb]

Good afternoon,
I sent the tests indicated in the mail, but to other members of the forum that quizerem see the study or test alone ... follow the link of the executables used, the simple design the database script with function self population ...

https://www.dropbox.com/s/79me0cv5wtbrb ... ts.7z?dl=0

Saulo

[saulojb]

someone tested?

[FCS]

Hello,

I have tested your demos. I confirm the problem on local and remote access. It looks bad for me too.

I don't know how to include screen shots, but:

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

Really something is not good with 6.0.1 version.

I tested this demo compiled on BDS2006+UniDac 6.0.2 and results were the same as 6.0.1.

Regards
Michal

[azyk]

The investigation is in progress. We will notify you about the results as any are available.

[azyk]

We have fixed this problem. This fix will be included in the next UniDAC build.

[FCS]

Hello,

It is good news.

When this build will be available ?

Regards
Michal

[azyk]

The UniDAC release is planned for this month.