OpenEdge 10.2B SP7
I fill a dataset on the appserver. This takes like 700 ms for 2767 records.
This dataset is (at the client-side) attached to a bindingsource:
TopGridBindingSource:HANDLE = ghDSItemStock:TOP-NAV-QUERY.
After that opening the query ghDSItemStock:TOP-NAV-QUERY:QUERY-OPEN()
takes like 6 full seconds counting but MTIME info gives me 54 ms ???
Why is taking that long and how can i speed this up ??
Will the use of Batching on the ProBindingSource make the process faster? It should.
I assume a good portion of the time is caused by creating the rows in the (Ultra?)Grid. Any fancy styling on the Grid rows/cells?
Are there a lot of columns or Array fields in the temp-table? Remove those columns not required for the grid from the BindingSource schema.
Child relations? How many records in total?
Yes: narrowing down the ammount of columns (also arry fields) does the trick.
It's fast now...
Thanks for the help (Progress support needed database table definition, sourcecode etc etc to reproduce first)
no problem! For the binding source each array component is treated like an individual column and it seems that each column value gets passed over the bridge by its own. That makes a lot of traffic on the bridge.