Dave &/or Wempy
13-Feb-2006, 05:41 PM
This is wierd.
Production is version 11.0. PSQL8.1, driver 2.x
Data on a netware 5.1 server.
Runs "fine".
I copied everything over to a nw6.5, psql8.7 driver 3.x server for
vdf11.1 development and the speed sucked, so I pointed the vdf11.1
back at the 5.1 database, it still sucked.
Tried the query program, and dbexplorer, and access was instantaneous.
Ditto access from the cm programs that don't use DDs.
Went back to the dev 11.0 version, same data as production. Still
sucked. Production still okay.
Okay then, put dd_debug into one of the offending programs. F4 on the
key field displays the popup instantly, though selecting a record
takes about 300,000 finds before displaying the correct one in the
original form. F9 on the keyfield dbform takes about 770,000 finds
before returning the correct record.
Direct PSQL tests on the database are fine, STAT is fine, the .int
file is correct, it's obviously the DD not optimising somehow but this
thing hasn't been changed for at least a month and afaik the
production .exe contains the same version of the dd package so why
does the production server not act up?
What am I missing?
Broken DDF?
500,000 brain cells?
Dave
Production is version 11.0. PSQL8.1, driver 2.x
Data on a netware 5.1 server.
Runs "fine".
I copied everything over to a nw6.5, psql8.7 driver 3.x server for
vdf11.1 development and the speed sucked, so I pointed the vdf11.1
back at the 5.1 database, it still sucked.
Tried the query program, and dbexplorer, and access was instantaneous.
Ditto access from the cm programs that don't use DDs.
Went back to the dev 11.0 version, same data as production. Still
sucked. Production still okay.
Okay then, put dd_debug into one of the offending programs. F4 on the
key field displays the popup instantly, though selecting a record
takes about 300,000 finds before displaying the correct one in the
original form. F9 on the keyfield dbform takes about 770,000 finds
before returning the correct record.
Direct PSQL tests on the database are fine, STAT is fine, the .int
file is correct, it's obviously the DD not optimising somehow but this
thing hasn't been changed for at least a month and afaik the
production .exe contains the same version of the dd package so why
does the production server not act up?
What am I missing?
Broken DDF?
500,000 brain cells?
Dave