Re: [sqlite] associating a ticket in the UI to a check-in

Never mind, I just needed brackets. On Thu, Oct 18, 2012 at 8:07 PM, E. Timothy Uy wrote: > Is there a way to associate a ticket in the UI to a check-in or am I too > late? > > Thanks, > Tim > ___ sqlite-users mailing list

[sqlite] associating a ticket in the UI to a check-in

Is there a way to associate a ticket in the UI to a check-in or am I too late? Thanks, Tim ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Remote connection to SQLite db

Am 18.10.2012 15:41, schrieb Abhinav: Does SQL lite have an option of processes connecting to it from remote hosts with a port number? There's nothing directly built-in in the sqlite-library. In case you need that for Windows (also depends on your development- environment a bit) my

Re: [sqlite] Lemon: Non-terminal destructors and cleanup

On 18 Oct 2012, at 20:07, Richard Hipp wrote: > On Thu, Oct 18, 2012 at 3:03 PM, Ben wrote: > >> Hi list, >> >> I'm having a little trouble getting my head around memory management >> within a Lemon-generated parser. Specifically the part of the

Re: [sqlite] Lemon: Non-terminal destructors and cleanup

On Thu, Oct 18, 2012 at 3:03 PM, Ben wrote: > Hi list, > > I'm having a little trouble getting my head around memory management > within a Lemon-generated parser. Specifically the part of the docs stating > when a destructor will or will not be called. > > For example,

[sqlite] Lemon: Non-terminal destructors and cleanup

Hi list, I'm having a little trouble getting my head around memory management within a Lemon-generated parser. Specifically the part of the docs stating when a destructor will or will not be called. For example, this is a portion of a grammar based on the SQLite parse.y file: columnName ::=

Re: [sqlite] Processing time of a transaction

Perfect, thank you M. Hipp! Le 18 oct. 2012 à 20:32, Richard Hipp a écrit : > On Thu, Oct 18, 2012 at 1:57 PM, Paxdo Presse wrote: > >> >> Hello, >> >> in FAQ http://www.sqlite.org/faq.html : >> >> "Actually, SQLite will easily do 50,000 or more INSERT

Re: [sqlite] Processing time of a transaction

On Thu, Oct 18, 2012 at 1:57 PM, Paxdo Presse wrote: > > Hello, > > in FAQ http://www.sqlite.org/faq.html : > > "Actually, SQLite will easily do 50,000 or more INSERT statements per > second on an average desktop computer. But it will only do a few dozen > transactions per second.

[sqlite] Processing time of a transaction

Hello, in FAQ http://www.sqlite.org/faq.html : "Actually, SQLite will easily do 50,000 or more INSERT statements per second on an average desktop computer. But it will only do a few dozen transactions per second. Transaction speed is limited by the rotational speed of your disk drive. A

Re: [sqlite] CREATE INDEX is 13 times slower with 3.7.14.1 than with 3.6.22

No, I can't - 26s vs 15s (old vs new). But when I run the test in my Delphi test application, 3.7.14.1 takes 285 seconds (tested again right now). All the time, CPU usage is 25% (on a quad core). This is my test code: sqlite3_open('test.db', handle); t0:=now(); sqlite3_exec(handle,

Re: [sqlite] EXT :Re: CREATE INDEX is 13 times slower with 3.7.14.1 than with 3.6.22

I should mention I'm running Windows XP-64. 32-bit compile though. Michael D. Black Senior Scientist Advanced Analytics Directorate Advanced GEOINT Solutions Operating Unit Northrop Grumman Information Systems From: sqlite-users-boun...@sqlite.org

Re: [sqlite] EXT :Re: CREATE INDEX is 13 times slower with 3.7.14.1 than with 3.6.22

And using Dan's downloads 3.7.14.1 took 30.4 seconds 3.6.22 took 40.94 (there was a lot of idle time towards the end here...disk I/O I assume) Re-did my compilation again... 3.7.14.1 took 26.8 Recompiled under Visual Studio Express 2010 "cl /O2 sqlite3.c shell.c" 3.7.14.1 took 26.2 seconds I'm

Re: [sqlite] CREATE INDEX is 13 times slower with 3.7.14.1 than with 3.6.22

I used 3.7.14.1 Compiled thusly with Visual Studio Express 2008 cl /O2 sqlite3.c shell.c CREATE INDEX idx_namen_name ON Namen(name); Took 26.6 seconds and one CPU was pegged the whole time. I'm on a 3Ghz 8-core machine. Michael D. Black Senior Scientist Advanced Analytics Directorate Advanced

Re: [sqlite] CREATE INDEX is 13 times slower with 3.7.14.1 than with 3.6.22

On 10/18/2012 09:49 PM, Dan Kennedy wrote: On 10/18/2012 03:32 PM, Imanuel wrote: Ok, here it is (45mb): http://www.file-upload.net/download-6707980/CREATE_INDEX_test.7z.html On Linux here 3.6.22 takes around 61 seconds. Against 23 for a new version. Are you able to reproduce the performance

Re: [sqlite] CREATE INDEX is 13 times slower with 3.7.14.1 than with 3.6.22

On 10/18/2012 03:32 PM, Imanuel wrote: Ok, here it is (45mb): http://www.file-upload.net/download-6707980/CREATE_INDEX_test.7z.html On Linux here 3.6.22 takes around 61 seconds. Against 23 for a new version. Are you able to reproduce the performance regression with these two?

Re: [sqlite] System.Data.Sqlite writing chunks to a BLOB

I'd missed that - The devil is always in the detail (cue Homer Simpson "DOH!") Thanks again and sorry to be a nuisance On 18 October 2012 14:35, Richard Hipp wrote: > On Thu, Oct 18, 2012 at 9:03 AM, Mike King wrote: > >> At the moment it's difficult to

Re: [sqlite] Begin immediate transaction -> SQLITE_BUSY (database is locked)

On Thu, Oct 18, 2012 at 6:32 AM, Daniel Polski wrote: >> The SELECT statement, including the _prepare() stage and all the _step()s >> until you've reached the last row, and then the _finalize(), is all one >> process. They're all part of the statement and you can assume

Re: [sqlite] Bug report: Out-Of-Memory error when doing DELETE from a table with 150 million records

Hi Richard, Shouldn't the delete statement be able to flush it's stored rowids to disk when it understands the memory is not enough for handling. Otherwise it doesn't seem scalable enough. To avoid this we decided to change a database structure. I would consider this thread as not solving my

Re: [sqlite] Begin immediate transaction -> SQLITE_BUSY (database is locked)

On 18 Oct 2012, at 2:32pm, Daniel Polski wrote: > I logically do understand that there can't be 2 writers updating the database > at the same time, but I don't understand why the second insert statement in > the example below won't work without finalizing the SELECT

Re: [sqlite] Remote connection to SQLite db

Abhinav wrote: > Does SQL lite have an option of processes connecting to it from remote hosts > with a port number? No. SQLite is an embedded database, not a client/server one. -- Igor Tandetnik ___ sqlite-users mailing list

[sqlite] Remote connection to SQLite db

Hi, Does SQL lite have an option of processes connecting to it from remote hosts with a port number? Thanks, Abhinav Varshney ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Bug report: Out-Of-Memory error when doing DELETE from a table with 150 million records

The operating system is Windows7 x64 Ultimate, 4 Gb RAM I have not specified any PRAGMAs when run sqlite3.exe. The program was launched normally (in non-elevated mode). The database file is located on the local disk (C:) with a 95 GB of free space Here's how I launch this:

Re: [sqlite] System.Data.Sqlite writing chunks to a BLOB

On Thu, Oct 18, 2012 at 9:03 AM, Mike King wrote: > At the moment it's difficult to tell but I envisage 3-4gb being the > maximum. > The maximum BLOB size in SQLite is 1GB. So you would do well to store your images in separate files. > > Cheers, > > Mike > > On 18

Re: [sqlite] Begin immediate transaction -> SQLITE_BUSY (database is locked)

The SELECT statement, including the _prepare() stage and all the _step()s until you've reached the last row, and then the _finalize(), is all one process. They're all part of the statement and you can assume that the database is still locked until you do a _finalize(). If you are using the

Re: [sqlite] transaction commit is successful despite I/O error

On 18/10/2012 8:45 AM, Richard Hipp wrote: On Wed, Oct 17, 2012 at 4:11 PM, Efim Dyadkin wrote: Hi, I am testing loss of data in Sqlite database correlated to auto-mounter malfunction. I am running Sqlite on Linux and my database file is located on network disk. For a

Re: [sqlite] System.Data.Sqlite writing chunks to a BLOB

At the moment it's difficult to tell but I envisage 3-4gb being the maximum. Cheers, Mike On 18 October 2012 13:17, Joe Mistachkin wrote: > > Mike King wrote: >> >> Thanks - sorry to be a pain but is this on the roadmap for the future? >> (For the thing I'm playing with

Re: [sqlite] transaction commit is successful despite I/O error

On Wed, Oct 17, 2012 at 4:11 PM, Efim Dyadkin wrote: > Hi, > > I am testing loss of data in Sqlite database correlated to auto-mounter > malfunction. I am running Sqlite on Linux and my database file is located > on network disk. For a test I stop the auto-mounter right

[sqlite] transaction commit is successful despite I/O error

Hi, I am testing loss of data in Sqlite database correlated to auto-mounter malfunction. I am running Sqlite on Linux and my database file is located on network disk. For a test I stop the auto-mounter right before transaction is committed. Surprisingly commit succeeds without any error

Re: [sqlite] escape sequences for GLOB

On Thu, Oct 18, 2012 at 2:28 AM, Tristan Van Berkom wrote: > Hi all, >I've been around and around the documentation, run a sequence of > test cases and still haven't figured this out. > > What is the proper default escape sequence to be used for GLOB > pattern

Re: [sqlite] System.Data.Sqlite writing chunks to a BLOB

Mike King wrote: > > Thanks - sorry to be a pain but is this on the roadmap for the future? > (For the thing I'm playing with this is the difference between storing > images in the database or storing them in the filesystem). > Out of curiosity, what size images are you dealing with? Unless

Re: [sqlite] Begin immediate transaction -> SQLITE_BUSY (database is locked)

On 18 Oct 2012, at 10:55am, Daniel Polski wrote: > What if I create the SELECT sqlite3_stmt and want to step through the data to > evalute if an insert is needed? > If I find a matching row and create another sqlite3_stmt (INSERT) it will > convert the SELECT statement

Re: [sqlite] Creating a view

Thanks, Igor & Keith. gert ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] System.Data.Sqlite writing chunks to a BLOB

Thanks - sorry to be a pain but is this on the roadmap for the future? (For the thing I'm playing with this is the difference between storing images in the database or storing them in the filesystem). Cheers, On 18 October 2012 11:23, Joe Mistachkin wrote: > > Mike King

Re: [sqlite] System.Data.Sqlite writing chunks to a BLOB

Mike King wrote: > > That's great to know but is this supported in system.data.sqlite > or is there any plans to do so? > It's not being planned yet. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Begin immediate transaction -> SQLITE_BUSY (database is locked)

Pavel Ivanov skrev 2012-10-17 16:08: The problem is you are starting read-only transaction by executing SELECT and then try to convert this transaction into writing one by executing BEGIN IMMEDIATE. If in such situation SQLITE_BUSY is returned you have to finish the transaction and start it

Re: [sqlite] escape sequences for GLOB

Tristan Van Berkom wrote: > What is the proper default escape sequence to be used for GLOB > pattern matching in SQLite ? There are different escape mechanisms for different characters. A comment hidden in the source code explains: | Globbing rules: | | '*' Matches any sequence of zero

Re: [sqlite] CREATE INDEX is 13 times slower with 3.7.14.1 than with 3.6.22

Ok, here it is (45mb): http://www.file-upload.net/download-6707980/CREATE_INDEX_test.7z.html Imanuel Am 18.10.2012 00:37, schrieb Imanuel: > No, the performance stays the same. > I have also tried using a big cache_size, but that didn't change > anything, too. > > Yes, I can share the database

[sqlite] escape sequences for GLOB

Hi all, I've been around and around the documentation, run a sequence of test cases and still haven't figured this out. What is the proper default escape sequence to be used for GLOB pattern matching in SQLite ? I've already read in this other thread:

Re: [sqlite] System.Data.Sqlite writing chunks to a BLOB

That's great to know but is this supported in system.data.sqlite or is there any plans to do so? Cheers On Thursday, 18 October 2012, Simon Slavin wrote: > > On 17 Oct 2012, at 11:59pm, Mike King > > wrote: > > > I'm using the latest System.Data.Sqlite with