on 05-20-2009 2:17 AM
Hi,
today to test a pool of JDBC connections i use this command:
SELECT NOW() FROM DBA.DUAL
i'm using a lightweight command? or exists some other that can cost less to database?
thanks for any tip
Clóvis
>
SELECT NOW() FROM DBA.DUAL
Hi Clovis,
the command is pretty lightweight.
No IO is needed for that.
If you want to save even more CPU cycles, you may try switching to
SELECT user FROM DBA.DUAL
This should be a little tick quicker as it does not need to make a system call to get the current time.
Anyhow, the difference should be negligible.
regards,
Lars
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.