Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

(click on this box to dismiss)

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


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 4 years ago
75 Answers

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:

and here: ([:]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 4 years ago

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

Internet Explorer: Mozilla Firefox: Google Chrome: