P
pauldownie
Guest
Hi, I have a need for data from two tables to supply records to a browser. The main table has a one to zero or many relationship with the secondary table which supplies a single field to the browser. None of the fields are updatable. I am currently using a SDO with the two joined tables. It is important that the field from the secondary table can be used for sorting, but performance when sorting on this field against large data sets can result in long delays and a "not responding" message. This is the only real performance problem with this browser. Can this performance be improved if I were to use a SBO instead, or is there some other way to improve performance sufficiently on large data sets to solve this problem (all fields referenced and displayed from the secondary table are indexed). If that is not possible, is there a way to prevent a sort from being attempted when the data set is of a certain size? Sorting is really only necessary after filtering has been applied. thanks, Paul v. 10.2b Windows 7
Continue reading...
Continue reading...