[sqlite] FW: Very poor SQLite performance when using Win8.1 + Intel RAID1

This discussion, and you guys, are amazing. I am learning so much! On Wed, Mar 25, 2015 at 8:56 PM, Keith Medcalf wrote: > > On Wednesday, 25 March, 2015 10:42, Simon Slavin > said: > > >On 25 Mar 2015, at 1:47pm, Rob van der Stel < > RvanderStel at benelux.tokheim.com> wrote: > > >> One open

[sqlite] SQL Syntax To Copy A Table

Hi I know this must seem a fairly dumb question, but I can't find an easy way to create a copy of table using just SQL. My requirement is to take periodic snapshots of a names and addresses table, to be stored in the same database as the master. The master table has one index - an

[sqlite] SQL Syntax To Copy A Table

Hi Nige, create table as select * from See also http://www.sqlite.org/lang_createtable.html Martin Am 26.03.2015 um 16:29 schrieb Nigel Verity: > Hi > > I know this must seem a fairly dumb question, but I can't find an easy way to > create a copy of table using just SQL. > > My requirement

[sqlite] SQL Syntax To Copy A Table

On Thu, Mar 26, 2015 at 10:29 AM, Nigel Verity wrote: > Hi > > I know this must seem a fairly dumb question, but I can't find an easy way to > create a copy of table using just SQL. > > My requirement is to take periodic snapshots of a names and addresses table, > to be stored in the same

[sqlite] Query times vary between 0.2 s and 30 s for very

On Wed, 25 Mar 2015 10:02:24 + Simon Slavin wrote: > > On 25 Mar 2015, at 3:28am, James K. Lowden > wrote: > > > Is there some lower bound on either the size of the IN list or the > > number of rows in the table being queried? > > There's nothing in the language to stop you from