Re: Query Execution Time Perl/DBD

2001-11-21 Thread Gordan Bobic
On Wednesday 21 Nov 2001 12:11, Christian Andersson wrote: > The obvious way to do this would be to get the time before and after the > execution and then make a simple diff (after - before) I guess that is how > the mysql client does it (butI'm not sure) > I do not think that mysql itself provid

Re: Query Execution Time Perl/DBD

2001-11-21 Thread Mike(mickalo)Blezien
Try something like this: my $start = (times)[0]; # start # do you query execution here # done my $end = (times)[0]; Time: [${\($end - $start)}] seconds to process\n"; mysql sql database >>On Wed, 21 Nov 2001 13:11:29 +0100, "Christian Andersson" <[EMAIL PROTECTED]> wrote: >>- Original Me

Re: Query Execution Time Perl/DBD

2001-11-21 Thread Christian Andersson
The obvious way to do this would be to get the time before and after the execution and then make a simple diff (after - before) I guess that is how the mysql client does it (butI'm not sure) I do not think that mysql itself provides this information.. how to get the time in Perl/DBD I do not kno