How could it be that a DW object retrieves the data in 10 seconds in the DW painter, and 10 minutes in a DW control ?
The DW retrieves 241 rows and 1420 nested rows.
The DW control is pure PB, it contains no user event nor code. The window is also pure PB. The only code is in the window's open event and contains dw_1.SetTransObject(SQLCA) and dw_1.retrieve().
The DB is Oracle. The connection's parameters are the same in the IDE and the application, and so are the datasource and the data retrieved.
Any idea is welcome !