Re: [sqlite] SQLite3 internal performance

2014-12-30 Thread Edward Lau
rk; select max(doNothing) from bmark; select max(do1SQLiteMalloc) from bmark; select max(do1SQLiteMPrint) from bmark; Thanks. -Original Message- From: jungle Boogie <jungleboog...@gmail.com> To: General Discussion of SQLite Database <sqlite-users@sqlite.org> Sent: Sun

Re: [sqlite] SQLite3 internal performance

2014-12-28 Thread jungle Boogie
Hi Edward, On 25 December 2014 at 19:33, Edward Lau wrote: > > Hi Folks: > I have read in many posting that SQLite is fast. How fast is fast? So over > this holiday break I tried to take a reading on the VDBE performance to get a > general idea. I wrote a quick module to

[sqlite] SQLite3 internal performance

2014-12-27 Thread Edward Lau
Hi Folks: I have read in many posting that SQLite is fast. How fast is fast? So over this holiday break I tried to take a reading on the VDBE performance to get a general idea. I wrote a quick module to enable me to exercise the engine simulating 32M rows without any IOs. For each

[sqlite] SQLite3 internal performance

2014-12-27 Thread Edward Lau
Hi Folks: I have read in many posting that SQLite is fast. How fast is fast? So over this holiday break I tried to take a reading on the VDBE performance to get a general idea. I wrote a quick module to enable me to exercise the engine simulating 32M rows without any IOs. For each

Re: [sqlite] SQLite3 internal performance

2014-12-26 Thread Edward Lau
Re-posting due to message size too long. Hi Folks: I have read in many posting that SQLite is fast. How fast is fast? So over this holiday break I tried to take a reading on the VDBE performance to get a general idea. I wrote a quick module to enable me to exercise the engine simulating