Hi, ALL,
I am developing my application on Windows using MSVC 2010 32-bit and
test on Win 7 64-bit.
Recently I had to create a trigger (actually 2 triggers to populate
data in 2 tables).
After those triggers had been created the application start-up time
significantly increased (debug version
Igor Korot wrote:
After those triggers had been created the application start-up time
significantly increased.
On start-up it opens connection to the database and queries the table
that is not part of the trigger.
Any idea what to look for?
Are you creating one connection, or do you open
On Wed, Oct 30, 2013 at 12:36 AM, Clemens Ladisch clem...@ladisch.de wrote:
Igor Korot wrote:
After those triggers had been created the application start-up time
significantly increased.
On start-up it opens connection to the database and queries the table
that is not part of the trigger.
Hi,
I have the following Table :
CREATE TABLE users (
uid INTEGER PRIMARY KEY AUTOINCREMENT,
username VARCHAR(100) UNIQUE NOT NULL DEFAULT '',
email VARCHAR(255) UNIQUE NOT NULL
}
I wanted to know if I create an INDEX for the column email what isg going
to be the extra space the index will
On Wed, Oct 30, 2013 at 9:37 AM, Raheel Gupta raheel...@gmail.com wrote:
I tried to search for any docs on this but couldnt.
This table is going to have 1 Million records and I need to save space
here.
Any any all storage-related requirements, with the possible exception of
the page size[1],
Raheel Gupta wrote:
CREATE TABLE users (
uid INTEGER PRIMARY KEY AUTOINCREMENT,
username VARCHAR(100) UNIQUE NOT NULL DEFAULT '',
email VARCHAR(255) UNIQUE NOT NULL
I wanted to know if I create an INDEX for the column email what isg going
to be the extra space the index will occupy ?
About
On 30 Oct 2013, at 8:37am, Raheel Gupta raheel...@gmail.com wrote:
email VARCHAR(255) UNIQUE NOT NULL
}
I wanted to know if I create an INDEX for the column email what isg going
to be the extra space the index will occupy ?
Two things:
A) SQLite interprets VARCHAR(255) as TEXT. Each
I am pleased to announce the release of ODB 2.3.0.
ODB is an open source object-relational mapping (ORM) system for C++. It
allows you to persist C++ objects to a relational database without having
to deal with tables, columns, or SQL and without manually writing any of
the mapping code.
Major
On 30 Oct 2013, at 3:00am, RSmith rsm...@rsweb.co.za wrote:
Secondly, A query that seemingly requires no sorting sometimes give quite a
large figure for the Sort-Ops, what is it about this that I am not
understanding?
You may find that adding the information given by
EXPLAIN QUERY PLAN
On 30 Oct 2013, at 2:32am, Normand Mongeau nmong...@theobjects.com wrote:
Odd thing is that although I do have a 10 second timeout as soon as C goes
into a begin transaction A receives the SQLITE_BUSY error, in other words I
don't see any 10 second delay.
I'll try increasing the timeout.
Joe I tried you nmake line on a fresh extract of the .zip file from the
download page and got this:
1 file(s) copied.
C:\TFS\Main\source\lib\ThirdParty\sqlite_dbg\sqlite-src-3080100copy /Y .\src\ro
wset.c tsrc
1 file(s) copied.
Hi,
My sqlite database module has to store images (max. 100 KB) on client
machine.
1. store images on file system and have reference in database
2. store image as blob in database.
Which is the best way to store these images?
Any suggestions are welcome.
Best Regards,
va.
On Wed, Oct 30, 2013 at 7:30 AM, d b va230...@gmail.com wrote:
Hi,
My sqlite database module has to store images (max. 100 KB) on client
machine.
1. store images on file system and have reference in database
2. store image as blob in database.
Which is the best way to store these
Hallo,
for a SQLite db I would like to define a collation for german Umlaute
(don't know the english word for that, sorry) and Sonderzeichen (äöü,
ÄÖÜ, ß), so that:
a=A=ä=Ä
o=O=ö=Ö
u=U=ü=Ü
ß=s (or, better: ß=ss)
I want to use such a collation even on columns which are indeces, so I
would
Actually, I inspected carefully the code and to avoid any deadlocks and make
the intentions very explicit, every time we're about to write we do:
Begin immediate transaction
Our updates
Commit transaction
Anytime we read we do
Begin transaction
read
rollback transaction (there was a mix of
On Wed, Oct 30, 2013 at 8:51 AM, Ulrich Goebel m...@fam-goebel.de wrote:
Hallo,
for a SQLite db I would like to define a collation for german Umlaute
(don't know the english word for that, sorry) and Sonderzeichen (äöü,
ÄÖÜ, ß), so that:
a=A=ä=Ä
o=O=ö=Ö
u=U=ü=Ü
ß=s (or, better: ß=ss)
Hello d,
I prefer them in the DB so, I can move them as a package. I have 30-40
GB DB's filled with image files. Performance is decent. I do keep the
blobs in one table and meta-data in another.
C
Wednesday, October 30, 2013, 7:30:58 AM, you wrote:
db Hi,
db My sqlite database module has to
On 10/30/2013 8:51 AM, Ulrich Goebel wrote:
I want to use such a collation even on columns which are indeces, so I
would like to connect the collation to the column/index at the time
creating the column/index, not only in the later SELECTs. And I suppose,
that I really don't have to specify the
On Wed, Oct 30, 2013 at 9:10 AM, Teg t...@djii.com wrote:
I do keep the
blobs in one table and meta-data in another.
Good point, and worth repeating.
If you store large BLOBs in your database, performance will be much better
if you keep them in a separate table something like this:
On 30 Oct 2013, at 1:00pm, Normand Mongeau nmong...@theobjects.com wrote:
Could this be related to this: in A, the database connection is created in
the main program, but is passed down to a dll that loads another dll that
uses the connection to do the writes. Maybe the dll should open its
Hi,
I tried to convert our custom tables and triggers into partial indexes.
Unfortunately it seems that the query planner is unable to recognize
identical terms. Could this be fixed or is there any workaround?
Thanks,
Filip Navara
SQLite version 3.8.1 2013-10-17 12:57:35
Enter .help for
Using the straight C API of SQLite.
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Simon Slavin
Sent: October-30-13 9:39 AM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Problem with SQLITE_BUSY
On 30 Oct
On Wed, Oct 30, 2013 at 9:47 AM, Filip Navara filip.nav...@gmail.comwrote:
Hi,
I tried to convert our custom tables and triggers into partial indexes.
Unfortunately it seems that the query planner is unable to recognize
identical terms. Could this be fixed or is there any workaround?
Well finally found the problem: a forgotten sqlite3_finalize() call.
Very disturbing, I'd expect leakage, not the results I was seeing.
Normand
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Normand Mongeau
Sent:
On 30 Oct 2013, at 4:03pm, Normand Mongeau nmong...@theobjects.com wrote:
Well finally found the problem: a forgotten sqlite3_finalize() call.
Very disturbing, I'd expect leakage, not the results I was seeing.
SQLite has to keep the state of your SELECT available until you tell it you're
Then IMO the documentation for either sqlite3_prepare_xx or SQLITE_BUSY
should state this. It would have been helpful in my case, I was pulling my
hair looking at the transaction model which was sound.
-Original Message-
From: sqlite-users-boun...@sqlite.org
The documentation for BEGIN TRANSACTION
(http://www.sqlite.org/lang_transaction.html) does:
An implicit transaction (a transaction that is started automatically,
not a transaction started by BEGIN) is committed automatically when the
last active statement finishes. A statement finishes when
Yep OK. I stand corrected.
BTW thanks for your help.
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Igor Tandetnik
Sent: October-30-13 12:16 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Problem with SQLITE_BUSY
The
B) By insisting on your email values being unique you have already
required SQLite to make up an index for the column. SQLite needs that index
so that when you do an INSERT it can quickly check to see that the value
you use doesn't already exist.
Agreed. I was just asking the general space
On 30 Oct 2013, at 6:32pm, Raheel Gupta raheel...@gmail.com wrote:
I wanted to create an INDEX (not unique) of the md5sum column. Would the
index also eat up 20 Bytes or more than that ?
At least as much space as the total contents of all the md5sum values.
Assuming you did a VACUUM before
David Clark wrote:
NMAKE : fatal error U1045: spawn failed : No error
Stop.
From my research, it looks like this error is caused by a 64-bit versus
32-bit issue. What version Windows are you running? Is it 32-bit or
64-bit? Which ActiveTcl distribution file did you install?
--
Joe
Search the Internet for an SQLite extension called unifuzz.c and see
if that does what you want in the way of character folding. I have a
copy of the code on my other computer if you cannot find the original
authors original code.
I didn't write it, but it basically implements a NOCASE
Hi, Clemens et al,
On Wed, Oct 30, 2013 at 1:11 AM, Igor Korot ikoro...@gmail.com wrote:
Clemens,
On Wed, Oct 30, 2013 at 12:47 AM, Igor Korot ikoro...@gmail.com wrote:
On Wed, Oct 30, 2013 at 12:36 AM, Clemens Ladisch clem...@ladisch.de wrote:
Igor Korot wrote:
After those triggers had
33 matches
Mail list logo