Re: [sqlite] Suggestion for syntax enhancement for virtual tables
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 store (even if a non-temporary virtual table is still connected)? -Ursprüngliche Nachricht- Von: Baruch Burstein [mailto:bmburst...@gmail.com] Gesendet: Donnerstag, 01. Jänner 2015 08:38 An: General Discussion of SQLite Database Betreff: [sqlite] Suggestion for syntax enhancement for virtual tables For creating temporary virtual tables, currently you need to do: CREATE VIRTUAL TABLE temp.t ... Can this syntax be made to work too (similar to creating regular tables)? CREATE VIRTUAL TEMP TABLE t ... or CREATE TEMP VIRTUAL TABLE t ... -- ˙uʍop-ǝpısdn sı ɹoʇıuoɯ ɹnoʎ 'sıɥʇ pɐǝɹ uɐɔ noʎ ɟı ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Suggestion for syntax enhancement for virtual tables
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)? -Ursprüngliche Nachricht- Von: Baruch Burstein [mailto:bmburst...@gmail.com] Gesendet: Donnerstag, 01. Jänner 2015 08:38 An: General Discussion of SQLite Database Betreff: [sqlite] Suggestion for syntax enhancement for virtual tables For creating temporary virtual tables, currently you need to do: CREATE VIRTUAL TABLE temp.t ... Can this syntax be made to work too (similar to creating regular tables)? CREATE VIRTUAL TEMP TABLE t ... or CREATE TEMP VIRTUAL TABLE t ... -- ˙uʍop-ǝpısdn sı ɹoʇıuoɯ ɹnoʎ 'sıɥʇ pɐǝɹ uɐɔ noʎ ɟı ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Question regarding Sqlite In-Memory DB Insert
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 time (~1 minute) whether in the command line shell or using Python. Using an on-disk database rather than a :memory: database takes a little longer, but still many times faster than you report (~2 minutes or just under twice as long). You do not report the versions of anything you are using and this information may be somewhat helpful. For example, are you using Sqlite 1.0 on Windows 286 with an 40 Megabyte MFM Hard Disk and 512 KB of RAM, or something a little more modern? --- Theory is when you know everything but nothing works. Practice is when everything works but no one knows why. Sometimes theory and practice are combined: nothing works and no one knows why. >-Original Message- >From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- >boun...@sqlite.org] On Behalf Of Nihar Dash >Sent: Wednesday, 31 December, 2014 14:23 >To: sqlite-users@sqlite.org >Subject: [sqlite] Question regarding Sqlite In-Memory DB Insert > >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 >minutes. No change in logic The DataSource is flat file. I am curious why >the insert is so slow when hosted in IIS? I tried to search but did to >get any answer. Any help here is highly appreciated. thanksNihar >___ >sqlite-users mailing list >sqlite-users@sqlite.org >http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Question regarding Sqlite In-Memory DB Insert
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 minutes. No change in logic The DataSource is flat file. I am curious why the insert is so slow when hosted in IIS? I tried to search but did to get any answer. Any help here is highly appreciated. thanksNihar ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Where do we post to share code? CTE: Long to Wide format
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 under which operating system except SQL; please specify what kind of coding you'd like to share with us. Unfortunately the managers of this list don't allow us to attach files so only source code. Kind regards | Cordiali saluti | Vriendelijke groeten | Freundliche Grüsse, Klaas `Z4us` V - OrcID -0001-7190-2544 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
