Hello community,
I have a problem where SQL Developer's (4.0.3 version) export to excel works extremely slow. I have a query which fetches 20k rows and its performance is ok - around 1.3 minutes. But when I want to export the results to excel it takes about 2 hours.
One of my colleagues is working on SQL Developer version 3.0.04 and he doesn't have such problem - export finishes within 5 minutes.
What might be the cause? I didn't observe any huge memory consumption. I wonder if there might be decoding/encoding going on which slows down the export. Any suggestion where and what to look at?
Thank you, Viktor Ozerov