performancelog

一个内存数据库的源代码这是服务器端还有客户端

======================== 5 jul 2005 ===================
Setup on Gio version 4.9 kernel
The compilation mode for both V5 is CFLAGS=-O2 
command: time Mserver -c perf.conf TST </dev/null >/dev/null
		gio( load 0)		 
base		 0.06/0.04/0.02	
tst400a		 0.12/0.10/0.02	1M loop	 	
tst400a2	 0.23/0.20/0.02	1M loop inc	
tst400bHuge	 0.30/0.27/0.03	100k count (io)
tst400cHuge	 0.44/0.39/0.03	100k insert(io)	
tst400d		 0.70/0.67/0.02	1M insert tuple 
tst400e		 0.74/0.71/0.02	1M incr fcn     

tst901a		 0.77/0.72/0.04	[+] call	 
tst901b		 3.50/3.38/0.08	[+] call	
======================== 11 jul 2005 ===================
Setup on Gio version 4.9 kernel after complete recompilation
The compilation mode for both V5 is CFLAGS=-O2 
command: time Mserver -c perf.conf TST </dev/null >/dev/null
		gio( load 0)		 
base		 0.06/0.04/0.02	
tst400a		 0.11/0.09/0.02	1M loop	 	
tst400a2	 0.16/0.14/0.02	1M loop inc	
tst400bHuge	 0.24/0.20/0.04	100k count (io)
tst400cHuge	 0.32/0.26/0.05	100k insert(io)	
tst400d		 0.40/0.38/0.02	1M insert tuple 
tst400e		 0.46/0.44/0.02	1M incr fcn     

tst901a		 0.45/0.41/0.04	[+] call	 
tst901b		 1.85/1.78/0.06	[+] call	
======================== 16 aug 2005 ===================
Setup on Gio version 4.9 kernel after beautifier
The compilation mode for both V5 is CFLAGS=-O2 
command: time Mserver -c perf.conf TST </dev/null >/dev/null
		gio( load 0)		 
base		 0.055/0.038/0.014	
tst400a		 0.106/0.091/0.014	1M loop	 	
tst400a2	 0.163/0.145/0.013	1M loop inc	
tst400bHuge	 0.269/0.216/0.046	100k count (io)
tst400cHuge	 0.363/0.318/0.045	100k insert(io)	
tst400d		 0.412/0.374/0.025	1M insert tuple 
tst400e		 0.470/0.440/0.021	1M incr fcn     

tst901a		 0.472/0.416/0.040	[+] call	 
tst901b		 2.036/1.910/0.067	[+] call	
======================== 19 aug 2005 ===================
Setup on Gio version 4.9 kernel after code squeeze
The compilation mode for both V5 is CFLAGS=-O2 
command: time Mserver -c perf.conf TST </dev/null >/dev/null
		gio( load 0)		 
base		 0.055/0.038/0.014	
tst400a		 0.111/0.091/0.014	1M loop	 	
tst400a2	 0.165/0.147/0.013	1M loop inc	
tst400bHuge	 0.249/0.200/0.034	100k count (io)
tst400cHuge	 0.327/0.266/0.045	100k insert(io)	
tst400d		 0.444/0.409/0.025	1M insert tuple 
tst400e		 0.412/0.387/0.015	1M incr fcn     

tst901a		 0.508/0.445/0.040	[+] call	 
tst901b		 2.048/1.914/0.053	[+] call	
======================== 20 aug 2005 ===================
Setup on Gio version 4.9 kernel after enabling alloc_map
The compilation mode for both V5 is CFLAGS=-O2 
command: time Mserver -c perf.conf TST </dev/null >/dev/null
		gio( load 0)		 
		MonetDB 5				MonetDB 4.9.3
base		 0.048/0.036/0.012			0.033/0.024/0.009   0.7
tst400a		 0.104/0.093/0.011	1M loop	 	0.870/0.859/0.011   8.3
tst400a2	 0.155/0.149/0.006	1M loop inc		
tst400bHuge	 0.222/0.184/0.039	100k count (io) 1.115/0.963/0.152   5.0
tst400cHuge	 0.306/0.266/0.040	100k insert(io)	1.693/1.466/0.217   5.5
tst400d		 0.409/0.381/0.027	1M insert tuple 2.519/2.503/0.015   6.1
tst400e		 0.382/0.365/0.016	1M incr fcn     1.787/1.777/0.010   4.7

tst901a		 0.462/0.431/0.031	[+] call    2.474/2.430/0.044   5.3
tst901b		 1.865/1.776/0.059	[+] call    7.309/7.244/0.064   3.9
======================== 13 sep 2005 ===================
Setup on Gio version 4.9 kernel 
The compilation mode for both V5 is CFLAGS=-O2 
command: time Mserver -c perf.conf TST </dev/null >/dev/null
		gio( load 0)		 
		MonetDB 5				MonetDB 4.9.3
base		 0.048/0.036/0.012			0.033/0.024/0.009   0.7
tst400a		 0.114/0.098/0.016	1M loop	 	0.870/0.859/0.011   8.3
tst400a2	 0.165/0.149/0.016	1M loop inc		
tst400bHuge	 0.252/0.218/0.031	100k count (io) 1.115/0.963/0.152   5.0
tst400cHuge	 0.304/0.251/0.047	100k insert(io)	1.693/1.466/0.217   5.5
tst400d		 0.310/0.282/0.022	1M insert tuple 2.519/2.503/0.015   6.1
tst400e		 0.399/0.374/0.018	1M incr fcn     1.787/1.777/0.010   4.7

tst901a		 0.473/0.324/0.042	[+] call    2.474/2.430/0.044   5.3
tst901b		 1.702/1.615/0.054	[+] call    7.309/7.244/0.064   3.9
======================== 25 sep 2005 ===================
Setup on Gio version 4.9 kernel 
The compilation mode for both V5 is CFLAGS=-O2 
command: time Mserver -c perf.conf TST </dev/null >/dev/null
		gio( load 0)		 
		MonetDB 5				MonetDB 4.9.3
base		 0.066/0.046/0.020				0.033/0.024/0.009   0.5
tst400a		 0.116/0.102/0.014	1M loop	 	0.870/0.859/0.011   7/5
tst400a2	 0.169/0.159/0.011	1M loop inc		
tst400bHuge	 0.242/0.197/0.045	100k count (io) 1.115/0.963/0.152   4.6
tst400cHuge	 0.290/0.242/0.048	100k insert(io)	1.693/1.466/0.217   5.8
tst400d		 0.307/0.284/0.022	1M insert tuple 2.519/2.503/0.015   8.2
tst400e		 0.392/0.374/0.018	1M incr fcn     1.787/1.777/0.010   4.5

tst901a		 0.368/0.320/0.047	[+] call    2.474/2.430/0.044   6.7
tst901b		 1.665/1.603/0.061	[+] call    7.309/7.244/0.064   4.3
smalltable   0.077/0.058/0.019
======================== 5 okt sep 2005 ===================
Setup on Gio version 4.9 kernel , after SQL has been included
and 'all' data structures are properly released.
The compilation mode for both V5 is CFLAGS=-O2 
command: time Mserver -c perf.conf TST </dev/null >/dev/null
		gio( load 0)		 
		MonetDB 5				MonetDB 4.9.3
base		 0.098/0.057/0.020				0.033/0.024/0.009   0.5
tst400a		 0.151/0.131/0.019	1M loop	 	0.870/0.859/0.011   7/5
tst400a2	 0.215/0.164/0.021	1M loop inc		
tst400bHuge	 0.291/0.227/0.047	100k count (io) 1.115/0.963/0.152   4.6
tst400cHuge	 0.345/0.254/0.050	100k insert(io)	1.693/1.466/0.217   5.8
tst400d		 0.347/0.299/0.029	1M insert tuple 2.519/2.503/0.015   8.2
tst400e		 0.447/0.390/0.020	1M incr fcn     1.787/1.777/0.010   4.5

tst901a		 0.428/0.343/0.048	[+] call    2.474/2.430/0.044   6.7
tst901b		 1.754/1.590/0.073	[+] call    7.309/7.244/0.064   4.3
smalltable   0.114/0.071/0.024
map100		 4.540/0.297/0.211
======================== 14 okt sep 2005 ===================
Setup on Gio version 4.9 kernel , after code squeezing for SQL
The compilation mode for both V5 is CFLAGS=-O2 
command: time Mserver -c perf.conf TST </dev/null >/dev/null
		gio( load 0)		 
		MonetDB 5				MonetDB 4.9.3
base		 0.065/0.040/0.020				0.033/0.024/0.009   0.5
tst400a		 0.115/0.088/0.028	1M loop	 	0.870/0.859/0.011   7.5
tst400a2	 0.168/0.144/0.024	1M loop inc		
tst400bHuge	 0.228/0.172/0.052	100k count (io) 1.115/0.963/0.152   4.9
tst400cHuge	 0.287/0.204/0.084	100k insert(io)	1.693/1.466/0.217   5.9
tst400d		 0.301/0.260/0.040	1M insert tuple 2.519/2.503/0.015   8.3
tst400e		 0.423/0.388/0.028	1M incr fcn     1.787/1.777/0.010   4.2

tst901a		 0.365/0.308/0.056	[+] call    2.474/2.430/0.044   6.7
tst901b		 1.576/1.488/0.088	[+] call    7.309/7.244/0.064   4.6
smalltable   0.074/0.060/0.012
======================== 16 nov sep 2005 ===================
Setup on Gio version 4.9 kernel , before and after Peter's MAL cleanup
The compilation mode for both V5 is CFLAGS=-O2 
command: time Mserver -c perf.conf TST </dev/null >/dev/null
		gio( load 0)		 
		MonetDB 5				MonetDB 4.9.3
base		 0.114/0.040/0.060				0.050/0.024/0.012   	0.160
tst400a		 0.164/0.100/0.056	1M loop	 	0.806/0.788/0.008   	0.964/0.940/0.020
tst400bHuge	 0.288/0.196/0.080	100k count (io) 1.161/0.948/0.160   4.560/4.396/0112
tst400cHuge	 0.333/0.240/0.084	100k insert(io)	1.737/1.428/0.224	2.357/2.224/0.128
tst400d		 0.364/0.284/0.068	1M insert tuple 2.352/2.240/0.024	2.528/2.500/0.024
tst400e		 0.471/0.412/0.044	1M incr fcn     1.668/1.628/0.024   1.990/1.964/0.024

tst901a		 0.427/0.352/0.064	[+] call    2.391/2.244/0.060   	2.659/2.484/0.076
tst901b		 1.712/1.608/0.088	[+] call    6.605/6.408/0.060   	7.248/7.104/0.072
smalltable   0.125/0.048/0.060
======================== 20 nov sep 2005 ===================
Setup on Gio version 4.9 kernel , After space reduction M5
The compilation mode for both V5 is CFLAGS=-O2 
command: time Mserver -c perf.conf TST </dev/null >/dev/null
		gio( load 0)		 
		MonetDB 5				MonetDB 4.9.3
base		 0.100/0.044/0.056				0.050/0.024/0.012   	0.160
tst400a		 0.144/0.092/0.052	1M loop	 	0.806/0.788/0.008   	0.964/0.940/0.020
tst400bHuge	 0.239/0.188/0.052	100k count (io) 1.161/0.948/0.160   4.560/4.396/0112
tst400cHuge	 0.290/0.212/0.076	100k insert(io)	1.737/1.428/0.224	2.357/2.224/0.128
tst400d		 0.335/0.292/0.044	1M insert tuple 2.352/2.240/0.024	2.528/2.500/0.024
tst400e		 0.455/0.404/0.052	1M incr fcn     1.668/1.628/0.024   1.990/1.964/0.024

tst901a		 0.403/0.332/0.072	[+] call    2.391/2.244/0.060   	2.659/2.484/0.076
tst901b		 1.610/1.504/0.106	[+] call    6.605/6.408/0.060   	7.248/7.104/0.072
smalltable   0.125/0.048/0.060
======================== 20 nov sep 2005 ===================
Setup on Gio version 4.9 kernel , After cleanup of statistics 
The compilation mode for both V5 is CFLAGS=-O2 
command: time Mserver -c perf.conf TST </dev/null >/dev/null
		gio( load 0)		 
		MonetDB 5							MonetDB 4.9.3
base		 0.055/0.044/0.012					0.032/0.024/0.008	0.6x
tst400a		 0.107/0.096/0.012	1M loop	 		0.869/0.860/0.008	8.1x  (16x)
tst400bHuge	 0.201/0.156/0.044	100k count (io) 1.632/1.564/0.068 	8.1x (10.9x)
tst400cHuge	 0.249/0.204/0.044	100k insert(io)	1.972/1.888/0.084   7.9x (9.8)
tst400d		 0.298/0.280/0.016	1M insert tuple  2.615/2.596/0.020	8.7x (10.6x)
tst400e		 0.408/0.388/0.020	1M incr fcn      1.759/1.744/0.016  4.3x (4.9x)


tst901a		 0.361/0.316/0.044	[+] call    	2.653/2.620/0.032	7.3x (8.6x)
tst901b		 1.671/1.612/0.060	[+] call   		7.649/7.580/0.064	4.6x (4.7x)
smalltable   0.064/0.052/0.012
======================== 18 dec sep 2005 ===================
Setup on Gio version 4.9 kernel , After cleanup of statistics 
The compilation mode for both V5 is CFLAGS=-O2 
command: time Mserver -c perf.conf TST </dev/null >/dev/null
		gio( load 0)		 
		MonetDB 5							MonetDB 4.9.3
base		 0.055/0.044/0.012					0.032/0.024/0.008	
tst400a		 0.115/0.100/0.015	1M loop	 		0.869/0.860/0.008
tst400bHuge	 0.208/0.192/0.016	100k count (io) 1.632/1.564/0.068
tst400cHuge	 0.270/0.244/0.028	100k insert(io)	1.972/1.888/0.084
tst400d		 0.309/0.276/0.032	1M insert tuple  2.615/2.596/0.020
tst400e		 0.395/0.384/0.008	1M incr fcn      1.759/1.744/0.016

tst901a		 0.370/0.336/0.032	[+] call    	2.653/2.620/0.032
tst901b		 1.728/1.672/0.056	[+] call   		7.649/7.580/0.064
smalltable   0.064/0.052/0.012
======================== 10 jan 2006 ===================
Setup on Gio version 4.9 kernel , after code squeezing
Changed profile to ignore mapi thread
The compilation mode for both V5 is CFLAGS=-O2 
command: time Mserver -c perf.conf TST </dev/null >/dev/null
		gio( load 0)		 
		MonetDB 5							MonetDB 4.9.3
base		 0.073/0.044/0.024					0.032/0.024/0.008	0.4x
tst400a		 0.115/0.096/0.020	1M loop	 		0.869/0.860/0.008	7.5x (19.9x)
tst400bHuge	 0.210/0.164/0.040	100k count (io) 1.632/1.564/0.068   7.7x (11.6x)
tst400cHuge	 0.276/0.216/0.052	100k insert(io)	1.972/1.888/0.084	7.1x ( 9.5x)
tst400d		 0.310/0.272/0.024	1M insert tuple  2.615/2.596/0.020  8.4x (10.9x)
tst400e		 0.391/0.352/0.024	1M incr fcn      1.759/1.744/0.016	4.5x (5.4x)

tst901a		 0.378/0.304/0.060	[+] call    	2.653/2.620/0.032	7.0x (8.6x)
tst901b		 1.672/1.548/0.056	[+] call   		7.649/7.580/0.064	4.5x (4.7)
smalltable   0.064/0.052/0.012
======================== 18 mar 2006 ===================
Setup on Gio version 4.9 kernel , before Peter's all kernel changes take effect
Kernel changes related to BBP updates and caching now active
The compilation mode for both V5 is CFLAGS=-O2 
command: time Mserver -c perf.conf TST </dev/null >/dev/null
		gio( load 0)		 
		MonetDB 5							MonetDB 4.9.3
base		 0.056/0.040/0.016
tst400a		 0.097/0.072/0.024	1M loop
tst400bHuge	 0.196/0.164/0.032	100k count (io)
tst400cHuge	 0.256/0.216/0.040	100k insert(io)
tst400d		 0.365/0.292/0.065	1M insert tuple  
tst400e		 0.348/0.328/0.016	1M incr fcn

tst901a		 0.509/0.380/0.116	[+] call
tst901b		 1.813/1.556/0.224	[+] call   		
smalltable   0.064/0.052/0.012
======================== 11 apr 2006 ===================
Setup on Gio version 4.9 kernel, 
Athlon 64 3000+ converted to X2 3800

The compilation mode for both V5 is CFLAGS=-O2 
command: time Mserver -c perf.conf TST </dev/null >/dev/null
		gio( load 0)		 
		MonetDB 5							MonetDB 4.9.3
base		 0.051/0.036/0.012
tst400a		 0.089/0.076/0.012	1M loop
tst400bHuge	 0.177/0.156/0.020	100k count (io)
tst400cHuge	 0.232/0.200/0.032	100k insert(io)
tst400d		 0.310/0.256/0.052	1M insert tuple  
tst400e		 0.325/0.304/0.016	1M incr fcn

tst901a		 0.459/0.352/0.108	[+] call
tst901b		 1.645/1.408/0.232	[+] call   		
smalltable   0.059/0.032/0.024
======================== 28 May 2006 ===================
Setup on Gio version 4.9 kernel, 
Athlon 64 3000+ converted to X2 3800
The compilation mode for both V5 is CFLAGS=-O2 
command: time Mserver -c perf.conf TST </dev/null >/dev/null
		gio( load 0)		 
		MonetDB 5							MonetDB 4.9.3
base		 0.076/0.040/0.036					+25/ +4/+24 ms
tst400a		 0.114/0.084/0.032	1M loop			+15/ +8/+20 ms
tst400bHuge	 0.214/0.172/0.040	100k count (io)	+37/+16/+20 ms
tst400cHuge	 0.269/0.212/0.060	100k insert(io) +37/+12/+28 ms
tst400d		 0.372/0.288/0.084	1M insert tuple +62/+32/+32 ms
tst400e		 0.334/0.304/0.028	1M incr fcn		 +9/  0/+12 ms

tst901a		 0.521/0.336/0.188	[+] call		+62/-16/+80 ms
tst901b		 1.721/1.396/0.324	[+] call   		+76/-12/+92 ms
======================== 28 May 2006 ===================
Setup on Gio version 4.9 kernel, 
Athlon 64 3000+ converted to X2 3800
The compilation mode for both V5 is CFLAGS=-O2 
command: time Mserver -c perf.conf TST </dev/null >/dev/null
		gio( load 0)		 
		MonetDB 5							MonetDB 4.9.3
base		 0.088/0.052/0.034					
tst400a		 0.125/0.076/0.040	1M loop			
tst400bHuge	 0.223/0.168/0.056	100k count (io)	
tst400cHuge	 0.284/0.232/0.048	100k insert(io) 
tst400d		 0.410/0.292/0.084	1M insert tuple +62/+32/+32 ms
tst400e		 0.361/0.320/0.036	1M incr fcn		 +9/  0/+12 ms

tst901a		 0.532/0.369/0.160	[+] call		+62/-16/+80 ms
tst901b		 1.853/1.580/0.268	[+] call   		+76/-12/+92 ms