I'm experiencing very slow performance in displaying resultsets in dwo's on my computer if I run it through RDP (remote desktop).
The retrieve itself is lightning fast, but the displaying many rows in absolutely all dwo's in my app is becoming VERY slow.
1000 rows display instantly
2000 rows few sec
5000 rows 30+ sec (WOAH!!)
10000 rows 3 min
20000 rows 15 min
Without RDP, run locally, it is very fast.
I've turned off antivirus, no inheritance or extra code involved, simply a settransobject + retrieve and that's all.
Appeon Powerbuilder Standard Edition
Version 2017 R3 Build 1858
It's a Intel Core i7 3740QM CPU 4 core 8 threads processor @ 2.70GHz, 24 GB of 1600Hz SDRAM memory with an Win 10 64 bits operating system and all data running on a 1GB's tuned Samsung SSD disk. It should all be more than fine AFAIK, and it is, as long as I dont run it through RDP.
Task manager tells me one processor is working at 95-100% while the 7 others rest at 5%. Memory is fine, GPU is fine. But the whole PC slows down and everything is incredibly slow from start to end of displaying the retrieved data.
Maritech Systems AS