My query takes 3 min 16 seconds to run when I run it from managed code.
When I paste the generated sql to Oracle SQL Developer it takes about 8 seconds.
Why does it take so much longer from code? How can I make it faster? I have already followed the instructions found here: http://www.devart.com/forums/viewtopic.php?t=18928
regarding precompiling the query.
The query returns about 162k rows.
I've seen a few references to a switch called ObjectTrackingEnabled however I cannot figure out how to use that. My query is read-only so if could turn off change tracking that would most likely help.
Thanks,
Sam
Performance tips?
I'm still working on this.
I cannot figure out why my query is slower every time I run it.
I found this post which concerns me:
http://stackoverflow.com/questions/1781 ... a-provider
I've searched this site for any help, if you can send a link that will point me in the right direction I would definately appreciate it.
Thanks,
Sam
I cannot figure out why my query is slower every time I run it.
I found this post which concerns me:
http://stackoverflow.com/questions/1781 ... a-provider
I've searched this site for any help, if you can send a link that will point me in the right direction I would definately appreciate it.
Thanks,
Sam
Please refer to the Performance Considerations (Entity Framework) article (http://msdn.microsoft.com/en-us/library/cc853327.aspx).
I'm encountering the same performance issue regarding dotConnect for Oracle. Running a query in Oracle SQL Developer, it only takes fractions of a second. Inside Visual Studio, in a mock test, the query takes 2.5 seconds. In a production environment, we expect to query thousands of records and the length of time it takes to query the data is unacceptable.