Re: [sqlite] binding multiple values in a query

;t be hard to make a version that worked on floats or strings. Peter On Wednesday, February 11, 2015 3:46 PM, Jono Poff wrote: Hi, I wonder if anybody could give me a simple example in C to bind an array of values to a prepared statement? The effect I'm looking for is sqlite

[sqlite] binding multiple values in a query

Hi, I wonder if anybody could give me a simple example in C to bind an array of values to a prepared statement? The effect I'm looking for is sqlite3_stmt* stmt = Compile(db, "select * in Things where thing1 in ( );"); sqlite3_bind_???(stmt,0 ,); Cheers, Jon

Re: [sqlite] very slow fdsync() calls

On 20/03/2014 5:14 p.m., Nico Williams wrote: On Wed, Mar 19, 2014 at 8:03 PM, Jono Poff wrote: On 12/03/2014 12:01 p.m., Nico Williams wrote: ZFS recordsize Hi Nico, I have one (or two) last question(s)... All I need to do is prevent a single process ('process A') from being tim

Re: [sqlite] very slow fdsync() calls

On 12/03/2014 12:01 p.m., Nico Williams wrote: ZFS recordsize Hi Nico, I have one (or two) last question(s)... All I need to do is prevent a single process ('process A') from being time bound by making fsync() calls that clash with fsync() calls from other processes using other files in the

Re: [sqlite] very slow fdsync() calls

Thankyou both for the suggestions. I set locking_mode=EXCLUSIVE and journal_mode=PERSIST but sqlite still fsyncs the directories. I'll try building with SQLITE_DISABLE_DIRSYNC, but hoping for a config only fix :) I'll post another question to the list when I've explored these options a bit

[sqlite] very slow fdsync() calls

Hi, I have an application that uses sqlite3. Investigating a problem with the app stalling occasionally I found that (every hour or two) an fdsync() system call from sqlite3_step() was taking over 3 seconds to return. On closer investigation, the file descriptor in these calls point to the