Re: [sqlite] How to achieve fastest possible write performance for a strange and limited case

On Fri, 29 Mar 2013 15:17:52 -0400 Jeff Archer wrote: > I have previously made an apparently bad assumption about this so now I > would like to go back to the beginning of the problem and ask the most > basic question first without any preconceived ideas. > >

Re: [sqlite] TCL Test failures on ARM

On 2 Apr 2013, at 8:33am, Bk wrote: > 1) i am using Linux 32bit on the embedded device, is it okey to give > "-D_FILE_OFFSET_BITS=64 " ? Yep. Theoretically it may be a little slower or lack backward compatibility, but if it compiles at all, it should be fine. The other

Re: [sqlite] TCL Test failures on ARM

Hi, i have noticed that the tests pass if built with below command TCC = armv7l-timesys-linux-gnueabi-gcc -D_FILE_OFFSET_BITS=64 -DSQLITE_OS_UNIX=1 -I. -I${TOP}/src -I${TOP}/ext/rtree Where i have added "-D_FILE_OFFSET_BITS=64" . 1) i am using Linux 32bit on the embedded device, is it

[sqlite] ICU and collation strength [patch]

Hi I wanted to compare strings in a SQLite DB without caring for the accents and the case. I mean "Événement" should be equal to "evenèment". The ICU extension enables a case-insensitive LIKE, but 'é' will still be different from 'É'. Anyway, using the ICU LIKE won't use any index, so I was very