Clarion and PostgreSQL 9.1

[dEraCh2000]

Hi,

I'm currently transfering to postgre as a backend and faceing a wall.

problem. simple table browse with two linked tables. column sort enabled. when i click some column it takes a
very long time to load sorted data.
two related tables are required for sorting by column with names(columns from related tables).
it works normal if I pair up names using validate, but then I lose column sort.

Any solutions?

Kind regards

Kind regards
Armin

 

[dEraCh2000]

Hi,

An update,

when I link two tables, not by related tables, but just as a non related table, and write the custom join by hand
browse column sort works fine

there is some problem when I use dictionary relationship


Kind regards
Armin

 

[dEraCh2000]

Update 2,

it acrually works fine even with rekated table join, but only if there is one related table

with two related tables data sort is to slow

Kind regards
Armin

 

[uniglass]

Not much help but in situation like this I enable query login in PostgreSql. Queries generated by Clarion ODBC can be scary.

 

[dEraCh2000]

hi,

i'v analyzed the trace file.

when using mssql over odbc, a found a clear sql statement with an order by clause, but
with postgre over odbc, there is no such statement, and the cursor goes through recodrs sequentaly,
producing the slow browse refresh.

couple of solutons.
first, using custom join statements with the inner join option - only if the data is required, othewise youll get small set of data
second, writting views and using them as browse source, pairing related table columns in a view select
and third, using the custom joins and inner join optins with empty value rows in tables, zeros for integer and empty strings for character variables, coupled with some safeguard, to prevent deletion of such rows (probably table triggers).

For the time being, we have opted for the third option.

Kind regards
Armin