Re: [sqlite] Testing performance hypothesis of scanning a table with no indexes versus reading same data from a file

> On Mon, 21 Jul 2014 13:05:13 +, Markus Schaber > said: > Hi, > Von: David Canterbrie >> I've been tasked with trying to understand how much of a performance hit one >> would get if one had to scan a table in its entirety versus reading the same >> data stored as a

Re: [sqlite] Testing performance hypothesis of scanning a table with no indexes versus reading same data from a file

Hi, Von: David Canterbrie > I've been tasked with trying to understand how much of a performance hit one > would get if one had to scan a table in its entirety versus reading the same > data stored as a new-line (or some sort like that) from a file. > > The hypothesis I suppose we're trying to

Re: [sqlite] Testing performance hypothesis of scanning a table with no indexes versus reading same data from a file

On 18 Jul 2014, at 11:50pm, Richard Hipp wrote: > Hard to say. There are a lot of dependencies. A lot. There's no point in us publishing figures of any kind since they'll be useless for you. All someone could do is look at comparisons between the two things on one

Re: [sqlite] Testing performance hypothesis of scanning a table with no indexes versus reading same data from a file

On Fri, Jul 18, 2014 at 6:44 PM, David Canterbrie wrote: > Hello, > > I've been tasked with trying to understand how much of a performance hit > one would get if one had to scan a table in its entirety versus reading the > same data stored as a new-line (or some sort like

[sqlite] Testing performance hypothesis of scanning a table with no indexes versus reading same data from a file

Hello, I've been tasked with trying to understand how much of a performance hit one would get if one had to scan a table in its entirety versus reading the same data stored as a new-line (or some sort like that) from a file. The hypothesis I suppose we're trying to understand is that reading