DADE Postgresql via ODBC

rbuser

Using D7 and RBuilder 11, I am comparing report timings between PervasiveSQL
and PostgreSQL.

The report is identical and I find that when the DeviceType is Screen, it
takes less than a second to 'Calculate' using PervasiveSQL but 15 seconds
for the first page under PostgreSQL. I am using the PostgreSQL unicode ODBC
driver. I tried to switch to Zeos but am having trouble building the dpk
for D7 which I will pursue with the add-in provider.

What occurs during the 'Calculate' process for the viewer? The report has a
master DataView with three detail views.

Thanks!

Sher

nardmoseley

I downloaded the Zeos packages and the daZeosLib7 package and with some
minor mods was able to build them.

1. To build the Zeos packages modify the ZComponentDesign.dpk Requires
clause to include ZComponent.

2. To build the DADE plug-in to work with RB 11 for D7, modify the
daZeosLib7.dpk Requires clause

a. update the RB package references from 77 to 117

b. remove the reference to ZParse as there is no such package.



--
Nard Moseley
Digital Metaphors
www.digital-metaphors.com

rbuser

Thank you Nard, that did it.

FYI, the performance is identical to the ADO/ODBC connection! I thought I
had already restricted ZComponent.dcr in my ZComponentDesign package but I
had not. For others, if you receive this message:

'Cannot load package 'ZCore70.' It contains unit 'ZMessages,' which is also
contained in package 'ZComponentDesign70'.

Just follow Nard's instructions as noted above.

Thanks,

Sher