Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register


1
(click on this box to dismiss)

How do I show the duration of a query in CSQL ?

Hello, 

I have noticed that in CUBRID Manager you can easily see how much a SQL command took to accomplish. I want though to do this in CSQL also. 

Can it be done ?

If so, how ?
link comment (0)
asked 3 years ago
nicola_magdalena
248
75 Answers
0

select now() from db_root into :t1;

select <whatever you need>, now() - :t1 AS TimeDiff .... etc

 

..or something like this - I don't have access now to test the exact syntax.

See more here:

http://www.cubrid.org/manual/840/en/SYSDATETIME

and here:

http://www.cubrid.org/manual/840/en/SELECT-Overview ([:]identifier : By using the :identifier after TO (or INTO), you can save the data to be retrieved in the ':identifier' variable.)

 

Hope it helps.

 

link comment (0)
answered 3 years ago
impega
128
tagged




You are either using a very old browser or a browser that is not supported.
In order to browse cubrid.org you need to have one of the following browsers:



Internet Explorer: Mozilla Firefox: Google Chrome: