I can suggest a database-depend method. Some database, such as
postgresql, supports compiled store procedures. You can write
a stored procedure in c, then call the procedure at the end of
your query. But I have never tried this before.
On Mon, 12 Dec 2005 Liqun Cheng wrote :
> Hi,
>
> I am wondering how to insert a magic instruction in sql queries. I know we
> can use sethi to add magic instruction in C programs, now I am running
> quries in mysql, for exmpale, "mysql database < 1.sql". I'd like to add a
> magic instruction at the end of 1.sql, thus I can calculate the execution
> time of query 1.
>
> thanks!
> Legion
> _______________________________________________
> Gems-users mailing list
> Gems-users@xxxxxxxxxxx
> https://lists.cs.wisc.edu/mailman/listinfo/gems-users
|