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

Question

1

(click on this box to dismiss)

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 2 years ago

248

Answer 1

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:

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 2 years ago

128

Related Questions