If IndexFieldNames is empty TOraTable opens immediatly.
Opening TOraTable takes a long time if IndexFieldNames is not empty
even if that field is the primary index.
If I set IndexFieldNames of a detail TOraTable to that of the master table
and then try to open it,after a couple of minuets I get an exception class EOutOfMemory with message 'Out of Memory'.
LocalMasterDetail property is false.
Master table record number: 243963
Detail record namber: 1161713
Opening TOraTable takes a long time if IndexFieldNames<>''
Hello,
This behaviour is connected with the fact that local sorting is used when setting the IndexFieldNames property, i.e. ALL data is fetched to DataSet and after that it is sorted. If you have a lot of data, you should use server sorting – instead of defining the IndexFieldNames property you should define the OrderFields property value.
This behaviour is connected with the fact that local sorting is used when setting the IndexFieldNames property, i.e. ALL data is fetched to DataSet and after that it is sorted. If you have a lot of data, you should use server sorting – instead of defining the IndexFieldNames property you should define the OrderFields property value.