$B2+=ULP wrote:
> How can I get the time which a select query use?
> thank you!
>
>
If you are using version 7.2 or later, try the command
EXPLAIN ANALYZE <any query>
This will perform the query (even if it is a DELETE FROM <table>!)
and show the actual time.
/Oskar
Ps. You should check what your mail client puts in the from field
of you mail. It is quite unreadable...
--
/----------------------------------------------------------------------\
| Oskar Berggren beo(at)sgs(dot)o(dot)se |
| Network and Software Engineer SGS Datanätgrupp |
| Gothenburg, Sweden |
\----------------------------------------------------------------------/