Re: [sqlite] Hints for the query planner

2013-10-01 Thread Nico Williams
On Tuesday, September 10, 2013, Richard Hipp wrote: > SURVEY QUESTION: > > The question for today is what to call this magic hint function: > > (1) unlikely(EXPR) > (2) selective(EXPR) > (3) seldom(EXPR) > (4) seldom_true(EXPR) > (5) usually_not_true(EXPR) (1), on account of: it's already

Re: [sqlite] Version 3.8.1 beta

2013-10-01 Thread Joe Mistachkin
Warren Young wrote: > > It can't build a shared library (DLL) on Cygwin any more: > > ./libtool --mode=link gcc -g -O2 -DSQLITE_OS_WIN=1 -I. -I./src > -I./ext/rtree -D_HAVE_SQLITE_CONFIG_H -DBUILD_sqlite -DNDEBUG > -I/usr/include -DSQLITE_THREADSAFE=1 -DSQLITE_OMIT_LOAD_EXTENSION=1 > -o

Re: [sqlite] Version 3.8.1 beta

2013-10-01 Thread Warren Young
On 9/30/2013 07:39, Richard Hipp wrote: SQLite version 3.8.1 will be published before too much longer, probably. You can find beta versions at http://www.sqlite.org/download.html Comments, criticisms, and third-party testing of this beta is appreciated. It can't build a shared library (DLL)

Re: [sqlite] SqLITE .NET Question - Connection default timeout / dyingafter inactivity

2013-10-01 Thread Joe Mistachkin
Michael wrote: > > > 25/09/2013 09:28:01 :: SQLite error > > no such table: faxes > > Killing the program, then re-opening will let it run correctly for another > 24 hours. The function calls to generate the SqLITE connection on launch > and on resume are identical - same code is

[sqlite] SqLITE .NET Question - Connection default timeout / dying after inactivity

2013-10-01 Thread Michael
We have a fairly simple communications server set up here. We recently added electronic faxing. We're using a 3rd party component to handle that, which saves the faxes it receives to a SqLITE database. To tie it to our existing systems, we've hacked up a little synchronizer which scans the

Re: [sqlite] Version 3.8.1 beta

2013-10-01 Thread jose isaias cabrera
"Richard Hipp" wrote... SQLite version 3.8.1 will be published before too much longer, probably. You can find beta versions at http://www.sqlite.org/download.html Comments, criticisms, and third-party testing of this beta is appreciated. Installed it and tested our tool: it works as good as

[sqlite] version 3.8 query planner doesn't find same or better plan for simple query over rtree tables

2013-10-01 Thread Martin Riša
Hello , we are facing performance regression in sqlite version 3.8 and higher versions on queries over r-tree tables and are unable to solve them , so we are asking professionals to consider severity of described problem: description is little Littler but , contains everything relevat. we have