perl-modperl mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Clayton Cottingham aka drfrog" <drf...@smartt.com>
Subject Re: Fast DB access
Date Wed, 18 Apr 2001 18:58:01 GMT
[drfrog]$ perl fast_db.pl
postgres
16 wallclock secs ( 0.05 usr +	0.00 sys =  0.05 CPU) @ 400.00/s (n=20)
mysql
 3 wallclock secs ( 0.07 usr +	0.00 sys =  0.07 CPU) @ 285.71/s (n=20)
postgres
17 wallclock secs ( 0.06 usr +	0.00 sys =  0.06 CPU) @ 333.33/s (n=20)
mysql
 3 wallclock secs ( 0.01 usr +	0.01 sys =  0.02 CPU) @ 1000.00/s (n=20)


correct me if im wrong but if fast_db.pl is 
working right 
first set is insert
second set is select

find attached the modified ver of fast_db.pl
i sued to conduct this test


comp stats
running stock rpms from mandrake 7.2 for both 
postgresql and mysql
 3.23.23-beta of mysql and
7.02 of postgresql

[drfrog@nomad desktop]$ uname -a
Linux nomad.localdomain 2.2.18 #2 Tue Apr 17 22:55:04 PDT 2001 i686 unknown

[drfrog]$ cat /proc/meminfo
	total:	  used:    free:  shared: buffers:  cached:
Mem:  257511424 170409984 87101440 24219648 96067584 44507136
Swap: 254943232        0 254943232
MemTotal:    251476 kB
MemFree:      85060 kB
MemShared:    23652 kB
Buffers:      93816 kB
Cached:       43464 kB
SwapTotal:   248968 kB
SwapFree:    248968 kB
[drfrog]$ cat /proc/cpuinfo
processor	: 0
vendor_id	: AuthenticAMD
cpu family	: 6
model		: 3
model name	: AMD Duron(tm) Processor
stepping	: 1
cpu MHz 	: 697.535
cache size	: 64 KB
fdiv_bug	: no
hlt_bug 	: no
sep_bug 	: no
f00f_bug	: no
coma_bug	: no
fpu		: yes
fpu_exception	: yes
cpuid level	: 1
wp		: yes
flags		: fpu vme de pse tsc msr pae mce cx8 sep mtrr pge mca cmov pat
pse36 psn mmxext mmx fxsr 3dnowext 3dnow
bogomips	: 1392.64



i will recomp both the newest postgresql and  mysql 

not using any optimizing techs at all i'll post the 

config scripts i use
On Tue, 17 Apr 2001 18:24:43 -0700, clayton said:

> Matt Sergeant wrote:
>  
>  > On Tue, 17 Apr 2001, Differentiated Software Solutions Pvt. Ltd., wrote:
>  > 
>  >> H/W : Celeron 433 with 64 MB RAM, IDE HDD using RH 6.1, perl 5.005,
>  >> Postgres 6.5.3
>  > 
>  > 
>  > This is a very very old version of postgresql. Try it again with 7.1 for
>  > more respectable results.
>  > 
>  
>  
>  im very glad to see this thread
>  
>  i wanted a good benchmark for postgres and mysql
>  {i hope to transpose the sql properly!}
>  
>  i do have 7.1 installed and it is very sweet
>  
>  ill report back when i rerun under postgresql at the very least
>  
>  
>  
>  

-- 
back in the day
we didn't have no
old school
-dr. frog
http://www.hyperbomb.com
it sells itself

Mime
View raw message