A table with two columns, both integers, one column primary key. I iterate and insert 100,000 values. Then do 100,000 random updates.
On Tue, Mar 26, 2013 at 4:30 AM, Dan Kennedy <[email protected]> wrote: > On 03/26/2013 06:34 AM, Rob Turpin wrote: > >> Dan, >> >> I haven't heard anything more about this. I was wondering if you also >> think the CPU performance for sqlite4 should be better? Maybe you could >> help me with where I could focus my attention in looking into this. I >> know >> that's probably a big question to a potentially complex issue, but might >> as >> well ask. >> > > I'm interested to know too. I think I'll try to recreate the test > when I get the chance. How large an initial database are you using? > > Dan. > > > > > > >> Thanks, >> Rob >> >> On Mon, Mar 18, 2013 at 12:20 PM, Rob Turpin <[email protected]> wrote: >> >> I understand it's still under development, but was curious about the >>> difference. I have commented out all of the debug defines and enabled >>> -DNDEBUG=1 for the sqlite4 build. >>> >>> >>> On Mon, Mar 18, 2013 at 12:00 PM, Simon Slavin <[email protected] >>> >wrote: >>> >>> >>>> On 18 Mar 2013, at 5:28pm, Rob Turpin <[email protected]> wrote: >>>> >>>> With sqlite3 there's a large difference between the CPU time and wall >>>>> >>>> clock >>>> >>>>> time. No big deal, that's the I/O to disk. But then I'm wondering why >>>>> >>>> the >>>> >>>>> difference with sqlite4 is so small? >>>>> >>>> >>>> You know that SQLite4 is Not Ready for Primetime, right ? Might the >>>> distribution you're using have a bunch of debugging stuff in ? >>>> >>>> Simon. >>>> ______________________________**_________________ >>>> sqlite-users mailing list >>>> [email protected] >>>> http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**users<http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users> >>>> >>>> >>> >>> ______________________________**_________________ >> sqlite-users mailing list >> [email protected] >> http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**users<http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users> >> >> > ______________________________**_________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**users<http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users> > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
