INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Clarion and PostgreSQL 9.1

Clarion and PostgreSQL 9.1

(OP)
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

RE: Clarion and PostgreSQL 9.1

(OP)
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

RE: Clarion and PostgreSQL 9.1

(OP)
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

RE: Clarion and PostgreSQL 9.1

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

RE: Clarion and PostgreSQL 9.1

(OP)
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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close