I am using query.extend.where() within BaanERP 5.0c to pull records from 2 different companies within a type-3 display session. The solution works great but is very slow. We have confirmed that the speed problem is specifically due to:

query.extend.where("table._compnr = :comp1 or table._compnr = :comp2)

Does anyone know of a way to get all the records of a specific table from company1 and then all the records of the same table from company2 (via two separate queries) and then combine them into one list for the session to display ?

I'm wondering if there is a solution for pulling all these records into memory and then allowing the session to display them via using external array variables.

Any additional ideas are also welcome.

Any and all feedback would be greatly appreciated.
-David B. Clark
dbclark79@juno.com
:confused: :confused:

I hope it's a display session you're talking about.

Just an idea:
1. Create a new index for the session's main table, say index1 with the compnr field appended to it (I've never tried this).
2. Include the compnr field on the form in the correct position (order of the new key used in the session).

It might work for a display session.