Visual Foxpro - Slow Recordset Parse
Posted: Thu 12 Aug 2021 18:55
Hello -
It seems that the devart driver is significantly slower to load a result set than the Microsoft Visual Foxpro Driver.
It seems this way with either the 32 or 64bit drivers.
Ive determined that the RecordSet.MoveNext() method is where the bottleneck is. Is there any workaround for this, or has anyone else experienced this?
In my tests the 32bit Microsoft driver loads the results, and is able to parse the recordset almost immediately, while the devart driver takes significantly longer.
Any ideas?
[EDIT]
This is mostly an issue on a MS Server 2019 running as a Terminal Server (Remote Desktop Session host).
It seems that the devart driver is significantly slower to load a result set than the Microsoft Visual Foxpro Driver.
It seems this way with either the 32 or 64bit drivers.
Ive determined that the RecordSet.MoveNext() method is where the bottleneck is. Is there any workaround for this, or has anyone else experienced this?
In my tests the 32bit Microsoft driver loads the results, and is able to parse the recordset almost immediately, while the devart driver takes significantly longer.
Any ideas?
[EDIT]
This is mostly an issue on a MS Server 2019 running as a Terminal Server (Remote Desktop Session host).