Re: [sqlite] Fine tuning table indexes

On 2 Feb 2014, at 1:09am, Keith Medcalf wrote: > No access method (yet invented) in any product (yet invented) can use more > than a single traversal path through a collection of data at any given time > during a single traversal operation. Yeah, that's why I asked for a

Re: [sqlite] Fine tuning table indexes

As I recall, I recorded the source file and line number location of the query, the query and its plan. No execution time, because the time each query ran would have been heavily influenced by the amount of time the caller used in processing each row. It could have been done, but the query plan was

Re: [sqlite] Fine tuning table indexes

>> Would be interesting to see >> when and where that single index comes into play when multiple indexes >> are >> defined. >MS SQL allows for many sorts of indexes, and SQLite has only one. MS SQL >has a Tuning Wizard, which will recommend indexes to create or drop, but >SQLite has a better

Re: [sqlite] System.Data.SQLite Preloading and ASP.Net debugging

Eric Schultz wrote: > > One thing I did notice when debugging is that on these copied assemblies, > the Assembly.CodeBase property has the original location of the Assembly > before running. > I've added code to the native library pre-loader to attempt to handle using the code base of the

Re: [sqlite] Fine tuning table indexes

On 1 Feb 2014, at 4:21pm, Stephen Chrzanowski wrote: > What was the raw results of some of the queries? Obviously query and > explain, but did you also tag in time deltas pre and post queries? > > I'll have to read up more on EXPLAIN. I'm aware of how indexes work as >

Re: [sqlite] Boolean and DataReader

On 2/1/2014 12:26 PM, Klaas V wrote: |Igor Tandetnik wrote: | On 1/30/2014 7:20 PM, James K. Lowden wrote: |or define a constraint | | colname boolean check (colname in ('Y', 'N')) | |Of course you can use 0 and 1, but there's no technical advantage |There is a tiny

Re: [sqlite] Boolean and DataReader

|Igor Tandetnik wrote: | On 1/30/2014 7:20 PM, James K. Lowden wrote: |or define a constraint | |colname boolean check (colname in ('Y', 'N')) | |Of course you can use 0 and 1, but there's no technical advantage |There is a tiny advantage. Values 0 and 1 are special-cased in

Re: [sqlite] Fine tuning table indexes

What was the raw results of some of the queries? Obviously query and explain, but did you also tag in time deltas pre and post queries? I'll have to read up more on EXPLAIN. I'm aware of how indexes work as well as where and when you need to put them in, but, when I had my SQL training back on

Re: [sqlite] Error: near "SELECT": syntax error

jose isaias cabrera wrote: > now this command is working perfectly: > > BEGIN; INSERT OR REPLACE INTO LSOpenProjects >SELECT * FROM client.LSOpenProjects WHERE id IN >(SELECT id from LSOpenProjects WHERE >login != '20513925' AND >id = client.LSOpenProjects.id >

Re: [sqlite] ORDER BY issue v3.8.2 amalgamtion

On 1 Feb 2014, at 3:53am, Labar, Ken wrote: > Upgrading from 3.7.14.1 to 3.8.2 our previously sorted queries are no > longer sorted. > Testing this same database with the win7 binary 3.8.2 the query is correctly > sorted. Does your query include an ORDER BY clause ? If

Re: [sqlite] Database Grammar 101

On 1 Feb 2014, at 10:59am, RSmith wrote: > The plural of Index is always "Indices", never "Indexes". I started with 'indices' when posting to this list but I found that some of the many foreign readers of this list apparently missed my meaning. It's easy for someone

Re: [sqlite] Need pointers for better build integration and support of schema updates

Hi Andreas, Our application uses 3 Sqlite dbs and System.Data.Sqlite.dll (dropped by installer). Functionality allows users to start a new instance of one of the databases at run time. Hence we ship empty databases in a binary format, created by one of our developers. The process of making

Re: [sqlite] Database Grammar 101

Heh, was waiting for someone to point that out :) For the record, so does Oxford English dictionary - and on reconsideration, I should have been more clear. Indexes are very much "allowed" these days a plural of Index when not used in a technical sense, but (and this is a big but), this is due

Re: [sqlite] Database Grammar 101

On Sat, Feb 1, 2014 at 5:59 AM, RSmith wrote: > I know this is a Database forum (as opposed to a language forum) but > kindly allow me a quick interjection here since I have met this question > many times, as posed by Scott in a forum question: > > On 2014/02/01 06:01, Scott

[sqlite] Database Grammar 101

I know this is a Database forum (as opposed to a language forum) but kindly allow me a quick interjection here since I have met this question many times, as posed by Scott in a forum question: On 2014/02/01 06:01, Scott Robison wrote: Exerpt: ...// *and* information that led to creation of

Re: [sqlite] order of = in join

Anbrus wrote: "what's the easiest way to generate a set of fixed number of rows like VALUES does but in an order of your choice?" Order them before with the command 'sort' NAME sort - sort lines of text files SYNOPSIS sort [OPTION]... [FILE]... DESCRIPTION Write sorted