Home DADE
New Blog Posts: Merging Reports - Part 1 and Part 2

DADE Postgresql via ODBC

edited December 2008 in DADE
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

Comments

  • edited December 2008


    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

    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
  • edited December 2008
    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
This discussion has been closed.