The latest sqlite addon v1.0.22 for j807 writes using binary values bound to columns. You should expect an order of magnitude better performance for both read/write compared to ddsqlite, for non-trivial data sets.
This is for j807 only, since the underlying code for write is completely new. If you want to use it in 806, install the 807 version, then if OK, copy the addon to your 806 addon directory. On Mon, Feb 19, 2018 at 3:53 PM, Ian Shannon < [email protected]> wrote: > Thanks Bill, I can see I will need to go to 806. > > I had problems with ddsqlite (after OS changes/fixes/...) so changed the > coding to use sqlite. > > sqlite did seem to be quicker, but binding binary values to columns should > be quicker than formatting values so a plus for ddsqlite. > > Ian ---------------------------------------------------------------------- For information about J forums see http://www.jsoftware.com/forums.htm
