Re: MySQL time

2005-03-15 Thread Octavian Rasnita
Hi,

Yes I know that I can benchmark the perl script using (times)[0] but I am
wondering if there is a method of getting the time returned by the MySQL
server.
Or that time shown by mysql client is not returned by MySQL server but by
that client in the same way I can do it using (times)[0]?

Thanks.

T
- Original Message - 
From: Chris Devers [EMAIL PROTECTED]
To: Octavian Rasnita [EMAIL PROTECTED]
Cc: Perl Beginners List beginners@perl.org
Sent: Monday, March 14, 2005 8:41 PM
Subject: Re: MySQL time


 On Mon, 14 Mar 2005, Octavian Rasnita wrote:

  Please tell me how can I find the time needed to pass for a perl
  program execute an SQL query using MySQL, DBI and DBD::mysql.

 You find the time required by benchmarking the procedure.

 If this isn't what you mean, maybe you could clarify what you mean by
 time (if you have some MySQL-specific concept of the term), and what
 it is exactly that you need (elapsed time to execute a query? elapsed
 time for a Perl/DBI script to connect to a MySQL server and issue a
 query? elapsed time for the whole Perl script to run? something else?).

 As always, posting the code you have so far is very helpful.


 -- 
 Chris Devers


-- 
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
http://learn.perl.org/ http://learn.perl.org/first-response




MySQL time

2005-03-14 Thread Octavian Rasnita
Hi,

Please tell me how can I find the time needed to pass for a perl program
execute an SQL query using MySQL, DBI and DBD::mysql.

(That time shown by the mysql standard client).

Thank you.

Teddy


-- 
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
http://learn.perl.org/ http://learn.perl.org/first-response




Re: MySQL time

2005-03-14 Thread Chris Devers
On Mon, 14 Mar 2005, Octavian Rasnita wrote:

 Please tell me how can I find the time needed to pass for a perl 
 program execute an SQL query using MySQL, DBI and DBD::mysql.

You find the time required by benchmarking the procedure.

If this isn't what you mean, maybe you could clarify what you mean by 
time (if you have some MySQL-specific concept of the term), and what 
it is exactly that you need (elapsed time to execute a query? elapsed 
time for a Perl/DBI script to connect to a MySQL server and issue a 
query? elapsed time for the whole Perl script to run? something else?). 

As always, posting the code you have so far is very helpful. 
 

-- 
Chris Devers

-- 
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
http://learn.perl.org/ http://learn.perl.org/first-response