We have a code that use recursion and filter on TOracleDataset to build a menu. In total there are about 1000 filter operations before the menu is finished. On my Windows 7 (64 bit) machine with 8 Gb of memory the menu is created in about 3 seconds.
However we have a customer using Citrix on a Windows 2008 R2 machine with 12 Gb of memory - there this code runs for about 75 seconds!
I have rewritten this code to read the data from the dataset into a memory representation and then I am doing filtering operations on this memory representation (Array of...) instead - still using the same recursive function. Now the meny builds in about a second in both platforms.
Why does the filter operation of TOracleDataset take this long? I assume it must be some memory setting - has anyone got a suggestion?
However we have a customer using Citrix on a Windows 2008 R2 machine with 12 Gb of memory - there this code runs for about 75 seconds!
I have rewritten this code to read the data from the dataset into a memory representation and then I am doing filtering operations on this memory representation (Array of...) instead - still using the same recursive function. Now the meny builds in about a second in both platforms.
Why does the filter operation of TOracleDataset take this long? I assume it must be some memory setting - has anyone got a suggestion?
