They are all the same to SQLite and declare a column with TEXT affinity.
-Ursprüngliche Nachricht-
Von: techi eth [mailto:techi...@gmail.com]
Gesendet: Montag, 15. Juli 2013 06:35
An: General Discussion of SQLite Database
Betreff: Re: [sqlite] Array Accessing in SQLite3
I found so many Ty
On Sat, Jul 13, 2013 at 5:14 AM, Dušan Paulovič wrote:
> Hello,
> we are currently facing problem with Access violation exception caused by
> function sqlite3_open_v2 trying to load extensions from unloaded DLLs.
>
New interface added: sqlite3_cancel_auto_extension(X). You can use this to
cance
I wrote an C++ application that uses sqlite3 to save part
of the data when it become larger than a known threshold.
The idea is to use at most a known quantity of memory;
to check if it is working I executed a relevant test
using valgrind's massif.
It worked fairly well most of the time, but in t
On Mon, Jul 15, 2013 at 8:39 PM, Paolo Bolzoni <
paolo.bolzoni.br...@gmail.com> wrote:
> So, sorry if the question sounds very vague. But what can
> cause high memory usage in sqlite? A large transaction
> maybe?
>
What is "high"? In my apps sqlite tends to use 200-400kb or so, which i
don't con
>From 35-40MB to 940MB; I would put massif result but I think the
list deletes attachments.
On Mon, Jul 15, 2013 at 8:41 PM, Stephan Beal wrote:
> On Mon, Jul 15, 2013 at 8:39 PM, Paolo Bolzoni <
> paolo.bolzoni.br...@gmail.com> wrote:
>
>> So, sorry if the question sounds very vague. But what ca
On 15 Jul 2013, at 7:49pm, Paolo Bolzoni wrote:
> From 35-40MB to 940MB; I would put massif result but I think the
> list deletes attachments.
Do you have in-memory tables ?
Do you use sqlite3_exec() ?
Do you have SELECTs for which there is no good index, forcing sqlite3 to make
up its own ?
On Mon, Jul 15, 2013 at 08:49:52PM +0200, Paolo Bolzoni scratched on the wall:
> >From 35-40MB to 940MB; I would put massif result but I think the
> list deletes attachments.
By default, the page-cache is 2000. Pages are typically 1KB, but
have some minor overhead in the cache. Assuming you
On Mon, Jul 15, 2013 at 8:59 PM, Simon Slavin wrote:
>
> On 15 Jul 2013, at 7:49pm, Paolo Bolzoni
> wrote:
>
>> From 35-40MB to 940MB; I would put massif result but I think the
>> list deletes attachments.
>
> Do you have in-memory tables ?
No.
> Do you use sqlite3_exec() ?
Twice, to activate t
On Mon, 15 Jul 2013 20:49:52 +0200
Paolo Bolzoni wrote:
> From 35-40MB to 940MB; I would put massif result but I think the
> list deletes attachments.
What does PRAGMA temp_store show? Set it to 0 and recheck. Did you compile with
SQLITE_TEMP_STORE set to 3?
--- ---
Eduardo Morras
On Mon, Jul 15, 2013 at 9:08 PM, Eduardo Morras wrote:
> On Mon, 15 Jul 2013 20:49:52 +0200
> Paolo Bolzoni wrote:
>
>> From 35-40MB to 940MB; I would put massif result but I think the
>> list deletes attachments.
>
> What does PRAGMA temp_store show? Set it to 0 and recheck. Did you compile
> w
I know that SQLite is inherently type-less, but I'm using
System.Data.SQLite which tries it very best to force that into the
common ADO.NET schema.
I'm having troubles with some text that has leading zeros, like '01',
'02' and so on. I'm reading that text out of an Oracle-DB into a SQLite
table
Thank you MR. Hipp...
Dušan
2013/7/15 Richard Hipp
> On Sat, Jul 13, 2013 at 5:14 AM, Dušan Paulovič
> wrote:
>
> > Hello,
> > we are currently facing problem with Access violation exception caused by
> > function sqlite3_open_v2 trying to load extensions from unloaded DLLs.
> >
>
> New inte
On 15 Jul 2013, at 9:18pm, Bernd wrote:
> I know that SQLite is inherently type-less, but I'm using System.Data.SQLite
> which tries it very best to force that into the common ADO.NET schema.
> I'm having troubles with some text that has leading zeros, like '01', '02'
> and so on. I'm reading
On 7/15/2013 1:18 PM, Bernd wrote:
I'm reading that text out of an Oracle-DB into a SQLite table
which has the affected column defined as 'String' - which maps to TEXT
in native SQLite
No. Look at section 2.1 of http://sqlite.org/datatype3.html Only CHAR,
CLOB, or TEXT cause the column
Am 15.07.2013 22:26, schrieb Simon Slavin:
On 15 Jul 2013, at 9:18pm, Bernd wrote:
I know that SQLite is inherently type-less, but I'm using System.Data.SQLite
which tries it very best to force that into the common ADO.NET schema.
I'm having troubles with some text that has leading zeros, li
Am 15.07.2013 22:30, schrieb Gerry Snyder:
On 7/15/2013 1:18 PM, Bernd wrote:
I'm reading that text out of an Oracle-DB into a SQLite table
which has the affected column defined as 'String' - which maps to TEXT
in native SQLite
No. Look at section 2.1 of http://sqlite.org/datatype3.html
16 matches
Mail list logo
