Poor performance with (local) sorting a lookupfield
Posted: Sun 06 May 2007 12:09
Hi,
The most recent build (5.00.1.6) of Mydac makes it posible to sort on lookupfields using the CRdbgrid. (GREAT!)
But:
There is an exeptional time differance between sorting a 'normal' field and a 'lookupfield'. Sorting is triggerd by clicking the column header.
The time difference is far too large:
- normal fields almost instanly.
- lookupfield(s) nearly 30 seconds by approx. 750 records in the crdbgrid).
The windows taskmanager shows the whole time 99% CPU time, and (of coarse) no network activity. (local sort).
The Crdbgrid connects with a Myquery (readonly) via a MyDataSource.
The most recent build (5.00.1.6) of Mydac makes it posible to sort on lookupfields using the CRdbgrid. (GREAT!)
But:
There is an exeptional time differance between sorting a 'normal' field and a 'lookupfield'. Sorting is triggerd by clicking the column header.
The time difference is far too large:
- normal fields almost instanly.
- lookupfield(s) nearly 30 seconds by approx. 750 records in the crdbgrid).
The windows taskmanager shows the whole time 99% CPU time, and (of coarse) no network activity. (local sort).
The Crdbgrid connects with a Myquery (readonly) via a MyDataSource.