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 -
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
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 again
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
http://sqlite.org:8080/cgi-
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 wrote:
>>
>> That's grea
Thanks,
Igor & Keith.
gert
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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 to a write transaction?
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 t
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 matching in SQLite ?
>
> I've al
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 althoug
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 before
> transaction is co
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 this is the difference b
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 test I stop the auto-mou
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
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 October 2012 13:17, Joe Mist
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:
C:\temp\131418>sqlite3.e
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
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-users@sqlite.org
h
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 query?
The fact that chang
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 curr
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 that the
>> database is st
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 tell but I envisage 3-4gb being the
>> m
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?
http://www.sqli
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 r
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 G
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 n
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 [sqlite
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, PAnsiCha
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 trans
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. Transaction spe
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 statements per
>> second on an averag
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 ::= n
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, this is a portion of a gram
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 docs stating
>> when a destructor will or will
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 SQLite-CO
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
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-users@sqlite.org
http:
On 10/18/2012 09:26 PM, Richard Hipp wrote:
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
pa
38 matches
Mail list logo