First Query Always Takes More Time Than Subsequent Queries Executed Within The Same Connection in JDBC
(Doc ID 1333080.1)
Last updated on JULY 29, 2019
Applies to:JDBC - Version 18.104.22.168 and later
Information in this document applies to any platform.
When queries are executed within the same connection in JDBC 10g or 11g, the first query independently of being complex or simple takes 300 ms to execute, and the second is faster.
The first query, no matter its complexity (even select 1 from dual), seems to incur an additional ~300ms penalty.
select 1 from dual; <-- slow
complex query <-- fast
Second run with different order of queries:
complex query <-- slow
select 1 from dual <-- fast
Why is this behavior?
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document