Thread Performance bei UPDATE (MySQL) (7 answers)
Opened by chmod777 at 2011-10-29 15:16

GwenDragon
 2011-10-31 14:42
#153692 #153692
User since
2005-01-17
14590 Artikel
Admin1
[Homepage]
user image
Na ja.
Zum Beispiel kannst du Methoden des Moduls CPAN:Time::HiRes verwenden.

Einfach um die zu testenden Codes was rum packen.

Beispiel:
Code (perl): (dl )
1
2
3
4
5
6
7
8
9
10

use Time::HiRes qw/gettimeofday tv_interval/;
...
...
...

$start_time = [gettimeofday];
$dbh->do("UPDATE ARTIKEL SET COUNT = COUNT +1 where REC_ID = '$rec_id'");
$elapsed_time  = tv_interval ($start_time);
...
...
die Drachin Gwen

View full thread Performance bei UPDATE (MySQL)