Re: [sqlite] CREATE TABLE/ALTER TABLE Slow Down When Table CountGrow

2016-10-10 Thread Simon Slavin
On 11 Oct 2016, at 3:45am, sanhua.zh wrote: > I’m altering the all table's names, which takes a long time to finish. > But now, I use ‘PRAGMA writable_schema=ON’ to alter them, which is written > athttps://www.sqlite.org/lang_altertable.html > Although it is easy to

Re: [sqlite] CREATE TABLE/ALTER TABLE Slow Down When Table CountGrow

2016-10-10 Thread sanhua.zh
I’m altering the all table's names, which takes a long time to finish. But now, I use ‘PRAGMA writable_schema=ON’ to alter them, which is written athttps://www.sqlite.org/lang_altertable.html Although it is easy to corrupt the database, but I do it careful enough, and testing adequate, it should

Re: [sqlite] Is it possible to support 64-bit value in rtree module?

2016-10-10 Thread Quan Yong Zhai
How about splits the 64 bits integer to two 32 bits integer, and store it in two fields of rtree table. 发自我的 Windows Phone 发件人: Gelin Yan 发送时间: ‎2016/‎10/‎11 1:23 收件人: SQLite mailing list

Re: [sqlite] "Responsive" website revamp at www.sqlite.org

2016-10-10 Thread Zsbán Ambrus
On Mon, Sep 5, 2016 at 10:55 PM, Richard Hipp wrote: > Most of the world views the internet on their phone now, I am told, > and websites are suppose to be "responsive", Most of the changes work well as far as I've seen, but I have one problem. The page

Re: [sqlite] Is it possible to support 64-bit value in rtree module?

2016-10-10 Thread Richard Hipp
On 10/10/16, Gelin Yan wrote: > Hi All > > As we know, the current rtree module supports 32-bit signed value > only, Is it > > possible to support 64-bit? Thanks. > This could be done, in theory. But it is of dubious utility, and not something the developers are

[sqlite] Is it possible to support 64-bit value in rtree module?

2016-10-10 Thread Gelin Yan
Hi All As we know, the current rtree module supports 32-bit signed value only, Is it possible to support 64-bit? Thanks. Regards gelin yan ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

Re: [sqlite] Parallel access to read only in memory database

2016-10-10 Thread Jens Alfke
> On Oct 9, 2016, at 10:41 AM, Howard Chu wrote: > > As for code freshness, I've seen no compelling new features from 3.8.x onward > that would improve performance so there's been no reason to update further. Perhaps, but there’s important new functionality in newer versions,

Re: [sqlite] Spelling error on current https://sqlite.org/csv.html

2016-10-10 Thread Richard Hipp
On 10/10/16, Mark Lawrence wrote: > Search for "scheam=" to find it. > Thanks for the report. Already fixed on https://sqlite.org/draft/ -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list

Re: [sqlite] Any way to disable transactional behavior?

2016-10-10 Thread Simon Slavin
On 10 Oct 2016, at 6:32am, Hayden Livingston wrote: > The problem is if I don't do a BEGIN TRANSACTION and do my inserts, it > takes absolutely forever for my program to finish (we're talking > hours). In traditional SQL it would be an error to try to do INSERT without

[sqlite] Spelling error on current https://sqlite.org/csv.html

2016-10-10 Thread Mark Lawrence
Search for "scheam=" to find it. -- Mark Lawrence ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] CREATE TABLE/ALTER TABLE Slow Down When Table Count Grow

2016-10-10 Thread Simon Slavin
On 10 Oct 2016, at 4:52am, sanhua.zh wrote: > I foundCREATE TABLE/ALTER TABLE Slow Down When Table Count Grow. Yes. SQLite needs to search through the (hashed) list of tables every time you give it a command that uses tables. The more tables there are, the longer it

Re: [sqlite] CREATE TABLE/ALTER TABLE Slow Down When Table CountGrow

2016-10-10 Thread sanhua.zh
more than 1 tables/indexes 原始邮件 发件人:Keith medcalfkmedc...@dessus.com 收件人:SQLite mailing listsqlite-us...@mailinglists.sqlite.org 发送时间:2016年10月10日(周一) 12:48 主题:Re: [sqlite] CREATE TABLE/ALTER TABLE Slow Down When Table CountGrow How many system objects do you have that this is a problem?

Re: [sqlite] Any way to disable transactional behavior?

2016-10-10 Thread Clemens Ladisch
Hayden Livingston wrote: > I have a program that writes hundreds of thousands of statements that > are logically unrelated, i.e. each is "transactional". > > The problem is if I don't do a BEGIN TRANSACTION and do my inserts, it > takes absolutely forever for my program to finish (we're talking >