Beefy Boxes and Bandwidth Generously Provided by pair Networks
Keep It Simple, Stupid
 
PerlMonks  

Re: Re: Re: How to count rows using DBI & mysql - Performance results

by busunsl (Vicar)
on Jun 11, 2001 at 18:09 UTC ( #87494=note: print w/ replies, xml ) Need Help??

Help for this page

Select Code to Download


  1. or download this
    Benchmark: timing 1000 iterations of Way1A, Way2A, Way2B, Way3A, Way4A
    +, Way4B, Way5A, Way5B, Way6A...
         Way1A: 52 wallclock secs ( 1.46 usr +  0.28 sys =  1.74 CPU) @ 57
    +4.05/s (n=1000)
    ...
    Way5A 780/s   36%   23%   16%   16%    5%    5%    --   -3%  -14%
    Way3A 806/s   40%   27%   20%   20%    8%    8%    3%    --  -11%
    Way5B 908/s   58%   43%   36%   36%   22%   22%   16%   13%    --
    
  2. or download this
    Benchmark: timing 1000 iterations of Way1A, Way2A, Way2B, Way3A, Way4A
    +, Way4B, Way5A, Way5B, Way6A...
         Way1A: 32 wallclock secs ( 0.93 usr +  0.18 sys =  1.11 CPU) @ 89
    +9.28/s (n=1000)
    ...
    Way1A 899/s   37%   31%   30%   19%   17%   11%    --   -4%   -5%
    Way5B 933/s   42%   36%   35%   23%   21%   15%    4%    --   -1%
    Way5A 943/s   43%   38%   36%   25%   23%   16%    5%    1%    --
    
  3. or download this
    Benchmark: timing 5000 iterations of Way1A, Way2A, Way2B, Way3A, Way4A
    +, Way4B, Way5A, Way5B, Way6A...
         Way1A: 43 wallclock secs ( 5.12 usr +  1.03 sys =  6.15 CPU) @ 81
    +3.14/s (n=5000)
    ...
    Way1A 813/s   12%   12%   12%   12%    9%    7%    --  -11%  -11%
    Way5A 909/s   25%   25%   25%   25%   22%   19%   12%    --   -0%
    Way5B 913/s   26%   26%   26%   25%   22%   20%   12%    0%    --
    
  4. or download this
    Engine Busy Utilization 
      Engine 0                       42.4 %                               
    +       
    ...
    
    Total Lock Requests              2391135
    
  5. or download this
    Engine Busy Utilization 
      Engine 0                       35.5 %                               
    +       
    ...
    
    Total Lock Requests              769881
    
  6. or download this
    Engine Busy Utilization 
      Engine 0                       37.3 %                               
    +       
    ...
      APL Heap Table                 10125
    
    Total Lock Requests              814515
    
  7. or download this
    Benchmark: timing 500 iterations of Way1A, Way2A, Way2B, Way3A, Way4A,
    + Way4B, Way5A, Way5B, Way6A...
         Way1A: 82 wallclock secs ( 0.55 usr +  0.17 sys =  0.72 CPU) @ 69
    +3.48/s (n=500)
    ...
      APL Heap Table                 20250
    
    Total Lock Requests              4331515
    
  8. or download this
    Benchmark: timing 500 iterations of Way1A, Way2A, Way2B, Way3A, Way4A,
    + Way4B, Way5A, Way5B, Way6A...
         Way1A: 48 wallclock secs ( 0.52 usr +  0.16 sys =  0.68 CPU) @ 73
    +4.21/s (n=500)
    ...
    
    Total Lock Requests               84663
    

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://87494]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others chanting in the Monastery: (6)
As of 2014-08-28 02:00 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The best computer themed movie is:











    Results (255 votes), past polls