NCLOBs cause slow speed...
Posted: Wed 15 Jul 2009 15:03
I'm using deth EF Provider for Oracle and have a performance problem with NCLOBS.
My table contains about 11.000 rows (incl. 3 nclobs) and takes about 30 seconds when fetching with an simple:
from c in myTable select c;
For a speed test I tried using a ado.net query into a datatable with the same result.
Ok, the EF provider isn't slower than ado.net.
B u t: If i use the same query "select * from myTable" within the OraDeveloper Studio it just takes 0,3 seconds!!
And I can see the nclob data in the grid!
How is this possible???
What the hell is done in the studio to have such a great performance??
How can I get that in the EF Provider?
I wrote a query just using non-NCLOB columns and the result was as fast as the studio result so it has to be a problem with fetching the nclobs!
But I need that damn nclob data...
Any ideas??
cew3
My table contains about 11.000 rows (incl. 3 nclobs) and takes about 30 seconds when fetching with an simple:
from c in myTable select c;
For a speed test I tried using a ado.net query into a datatable with the same result.
Ok, the EF provider isn't slower than ado.net.
B u t: If i use the same query "select * from myTable" within the OraDeveloper Studio it just takes 0,3 seconds!!
And I can see the nclob data in the grid!
How is this possible???
What the hell is done in the studio to have such a great performance??
How can I get that in the EF Provider?
I wrote a query just using non-NCLOB columns and the result was as fast as the studio result so it has to be a problem with fetching the nclobs!
But I need that damn nclob data...
Any ideas??
cew3