Are those directories on the same disk/partition?
What do the results look like if you replace "| sqlite" with "> /dev/null"?
I'm not 100% sure that you're timing the sqlite part here. I think you're
timing the cat, hence my earlier comments.
Try "time sqlite < /export/home/ykphuah/test.sql" (untested, but you get the
idea)
Martin
----- Original Message -----
From: "Phuah Yee Keat" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Wednesday, April 05, 2006 6:34 AM
Subject: [sqlite] Strange Behaviour on Solaris 8 on Sparc
Hi,
I am currently running some tests to decide whether to use sqlite, and
bump into some strange behavior. I compiled sqlite 3.3.4 from source and
installed it on a solaris 8 on sparc without any updates. I run the same
scripts (which insert 1000 entries without BEGIN/END block), on the same
machine, but in different directories, getting totally different results:
###
# In the "db1" directory:
###
[EMAIL PROTECTED]:~/db1$ time cat /export/home/ykphuah/test.sql | sqlite3
test.db
real 3m53.708s
user 0m0.710s
sys 0m2.140s
[EMAIL PROTECTED]:~/db1$ time cat /export/home/ykphuah/test.sql | sqlite3
test.db
real 3m48.267s
user 0m0.590s
sys 0m2.120s
[EMAIL PROTECTED]:~/db1$ time cat /export/home/ykphuah/test.sql | sqlite3
test.db
real 3m48.435s
user 0m0.630s
sys 0m2.100s
[EMAIL PROTECTED]:~/db1$
###
# In the "db2" directory:
###
[EMAIL PROTECTED]:~/db2$ time cat /export/home/ykphuah/test.sql | sqlite3
test.db
real 0m12.523s
user 0m0.650s
sys 0m1.960s
[EMAIL PROTECTED]:~/db2$ time cat /export/home/ykphuah/test.sql | sqlite3
test.db
real 0m6.296s
user 0m0.490s
sys 0m1.720s
[EMAIL PROTECTED]:~/db2$ time cat /export/home/ykphuah/test.sql | sqlite3
test.db
real 0m6.264s
user 0m0.470s
sys 0m1.750s
[EMAIL PROTECTED]:~/db2$
I am really puzzled as to why there's so much difference in the time to
execute the same script on the same box just in different directories,
thinking that it might be placement of the directories in the physical
disc itself causing the fsync calls to differ so much?
Is there any way where I can provide more information to help you guys
help me?
Thanks in advance.
Cheers,
Phuah Yee Keat
