Browse Column Sorting Slowness using PostgreSQL

[ThalesSilveirs]

I had a significant improvement when I changed my command line there in the dictionary, adding as a forum colleague gave me an example, here it is:

@seanh
/BUSYHANDLING=2 /ISOLATIONLEVEL=2 /JOINTYPE='ODBC 3.0' /NESTING=TRUE

Any idea how Multiple Join with PostgreSQL?

In a browse it should ‘Just Work’. I assume you mean putting it all in a SELECT with appropriate Joins? You might need a little extra on you dct definition. This is my standard for Postgres tables: /BUSYHANDLING=2 /ISOLATIONLEVEL=2 /JOINTYPE='ODBC 3.0' /NESTING=TRUE Note there is also a Windows ODBC Join limitation of 2 or 3 or something. So more complex stuff it’s better to put into a server side view Carl Barnes: Edit to add links to help for above parameters. https://clarion.help/dok…