Long execution time in new query window

Nime

Hi, it takes a long time to query anything like table.Take(100) or .Count. no matter the table is full or empty. It's about 2.5 seconds. After the initial query, subsequent queries in OPENED window take reasonable time, about 0.076 seconds.

It's not a cache problem. If I close the window and query table.Take(100) it takes another 2.5 seconds to display result in new window.

What would be the problem? Is it Linqpad issue, Oracle one or anything else?

Linqpad v4.48.01 anycpu, Windows 8 64 bit, Oracle 11 on Linux.

Puf

LINQPad creates an AppDomain the first time you run a query against a data source in a tab/window. Subsequent runs re-use that AppDomain. So you may be experiencing longer execution time due to the initialization of the AppDomain.

You can easily test this, by pressing Shift-F5 after executing the query a few times. Shift-F5 will discard the AppDomain, so that LINQPad will create a new AppDomain next time you run the query. So if the query is taking longer after you hit Shift-F5 too, you know that it's very likely to be caused by it spinning up an AppDomain for your query to run in.

Goyuix

Which driver are you using for your Oracle connection? The IQ Driver? If the IQ Driver, what are you using for you connection mode: Direct or OCI?

Does a similar "SELECT * FROM table WHERE ROWNUM < 100" exhibit similar performance in SQLPLUS?