Hi,
I would like to take a shot at asking this question here instead of
Linux kernel mailing list just in case anyone here have encountered this
issue before.
I am running sqlite 3.3.4.
On a desktop slackware 10.2 machine, I have installed two stock kernels
2.4.31 and 2.6.13. The box is using reiserfs.
I have attached a script that I use to generate a sql script to test.
The 2.4 kernel took 5 seconds to finish the sql script but the 2.6
kernel took 50 seconds. Here are the GNU time output:
Kernel 2.4===>
0.31user 1.54system 0:06.27elapsed 29%CPU (0avgtext+0avgdata 0maxresident)k
0inputs+0outputs (686major+184minor)pagefaults 0swaps
Kernel 2.6===>
0.48user 1.40system 0:52.24elapsed 3%CPU (0avgtext+0avgdata 0maxresident)k
0inputs+0outputs (0major+1040minor)pagefaults 0swaps
Any help will be greatly appreciated. I could provide more information
on the system as required.
Thanks in advance,
Phuah Yee Keat
#!/usr/bin/perl
printf "DROP TABLE IF EXISTS t1;\n";
printf "CREATE TABLE t1(a INTEGER, b INTEGER);\n";
for ($i=0;$i<1000;$i++) {
$r = int(rand())*100000;
printf("INSERT INTO t1 VALUES(%d,%d);\n", $i, $r);
}
