[Bug 459373] New: Bad SQLite Performance
https://bugzilla.novell.com/show_bug.cgi?id=459373 Summary: Bad SQLite Performance Product: openSUSE 11.1 Version: Final Platform: Other OS/Version: Other Status: NEW Severity: Normal Priority: P5 - None Component: Basesystem AssignedTo: bnc-team-screening@forge.provo.novell.com ReportedBy: michael.monreal@gmail.com QAContact: qa@suse.de Found By: --- Phoronix recently benchmarked recent linux distributions. In the sqlite test, openSUSE 11.1rc1 lagged behind badly¹. Maybe there is a problem with that package? I don't see any other reason why there should be such a difference in performance... [1] http://www.phoronix.com/data/img/results/intel_atom_four/6.png -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.
https://bugzilla.novell.com/show_bug.cgi?id=459373 User aorlovskyy@novell.com added comment https://bugzilla.novell.com/show_bug.cgi?id=459373#c1 Alexander Orlovskyy <aorlovskyy@novell.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |aorlovskyy@novell.com AssignedTo|bnc-team-screening@forge.provo.novell.com |max@novell.com --- Comment #1 from Alexander Orlovskyy <aorlovskyy@novell.com> 2008-12-16 04:54:48 MST --- Reinhard, can you comment on this bug ? -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.
https://bugzilla.novell.com/show_bug.cgi?id=459373 User max@novell.com added comment https://bugzilla.novell.com/show_bug.cgi?id=459373#c2 Reinhard Max <max@novell.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Priority|P5 - None |P4 - Low --- Comment #2 from Reinhard Max <max@novell.com> 2008-12-16 05:13:08 MST --- Unlike the other distros we don't build SQLite with dirsync disabled, but this shouldn't have much impact on performance, as the dirsync is only done once per temporary file that SQLite creates. If I understood the kernel gurus right, our kernel makes the sync() call actually do what it is supposed to, which makes it slower, but safer. I wouldn't want to sacrifice these data safety features just to win some performance crowns. But internal discussions of the cited test results have also shown that there does indeed seem to be a performance problem in the kernel, which is currently being investigated. So, I'll leave this one open until that bug has been fixed and it has been verified that SQLite then is only as much slower as you can expect from a non-disabled dirsync and an actually working sync() call. -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.
https://bugzilla.novell.com/show_bug.cgi?id=459373 User max@novell.com added comment https://bugzilla.novell.com/show_bug.cgi?id=459373#c3 --- Comment #3 from Reinhard Max <max@novell.com> 2008-12-16 07:16:33 MST --- BTW, the test suite they are using brings its own version of SQLite, so the performance difference can definitely not come from our SQLite package. -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.
https://bugzilla.novell.com/show_bug.cgi?id=459373 User max@novell.com added comment https://bugzilla.novell.com/show_bug.cgi?id=459373#c4 Reinhard Max <max@novell.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution| |INVALID --- Comment #4 from Reinhard Max <max@novell.com> 2009-01-07 07:12:33 MST --- I am closing this as INVALID, as the reason for the slowness is outside of the SQLite package and already being worked on and tracked elsewhere. -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.
https://bugzilla.novell.com/show_bug.cgi?id=459373 User aorlovskyy@novell.com added comment https://bugzilla.novell.com/show_bug.cgi?id=459373#c5 Alexander Orlovskyy <aorlovskyy@novell.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|RESOLVED |CLOSED --- Comment #5 from Alexander Orlovskyy <aorlovskyy@novell.com> 2009-01-07 07:30:11 MST --- Closing bug. -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.
participants (1)
-
bugzilla_noreply＠novell.com