Re: [sqlite] Suggestion for syntax enhancement for virtual tables

2015-01-01 Thread Dan Kennedy
On 01/02/2015 01:58 PM, Hick Gunter wrote: Temporary virtual tables sounds like an interesting concept. Does the xDestroy() function get called on such a beast (as opposed to xDisconnect() when the connection is closed)? Just xDisconnect(). Dan. Should that function delete the backing

Re: [sqlite] Suggestion for syntax enhancement for virtual tables

2015-01-01 Thread Hick Gunter
Temporary virtual tables sounds like an interesting concept. Does the xDestroy() function get called on such a beast (as opposed to xDisconnect() when the connection is closed)? Should that function delete the backing store (even if a non-temporary virtual table is still connected)?

Re: [sqlite] Question regarding Sqlite In-Memory DB Insert

2015-01-01 Thread Keith Medcalf
I think either (a) your computer is broken; (b) your database is broken; or, (c) your methodology is broken. While I cannot speak to the inherent (ample) inefficiencies of dotnot, inserting three times the number of records (that is, ~1 million with multiple indexes) takes one-fifth the

[sqlite] Question regarding Sqlite In-Memory DB Insert

2015-01-01 Thread Nihar Dash
HiI am using SQLite In-Memory DB for loading cache data into memory. I am using dotnet. The data I am inserting are .3 million. When I use the same number of records to insert in Console App it takes around 5 min. However If I host my app in IIS and Insert the same number of records It takes 60

Re: [sqlite] Where do we post to share code? CTE: Long to Wide format

2015-01-01 Thread Klaas V
Happy New Year, Joe and other SML-members, You answered your own question in the title of your post perfectly. If you want to post the results of .fullschema here as well you provide us with almost every detail of the way you coded your database. Perhaps you mean other code in what language and