r 2, 2011 12:41 PM
>Subject: Re: [sqlite] sqlite3_open_v2 performance degrades as number of opens
>increase
>
>
>On 2 Sep 2011, at 6:34pm, Terry Cumaranatunge wrote:
>
>> This does suggest that we should re-evaluate our design and not open as many
>> databases fr
On 2 Sep 2011, at 6:34pm, Terry Cumaranatunge wrote:
> This does suggest that we should re-evaluate our design and not open as many
> databases from a single process. The original motivation was to limit the
> size the database for performance reasons, which resulted in a large number
> of
size for a
database file?
From: Pavel Ivanov <paiva...@gmail.com>
>To: General Discussion of SQLite Database <sqlite-users@sqlite.org>
>Sent: Friday, September 2, 2011 9:28 AM
>Subject: Re: [sqlite] sqlite3_open_v2 performance degrades as number of opens
>increase
&
On Fri, Sep 02, 2011 at 06:30:57AM -0500, Terry Cumaranatunge scratched on the
wall:
> Hello,
>
> We have an application that creates many small databases (over 100K) to be
> able to control the size of the database and provide more deterministic
> performance. At process startup, it opens many
-users-boun...@sqlite.org] on
> behalf of Black, Michael (IS) [michael.bla...@ngc.com]
> Sent: Friday, September 02, 2011 8:00 AM
> To: General Discussion of SQLite Database
> Subject: EXT :Re: [sqlite] sqlite3_open_v2 performance degrades as number of
> opens increase
>
>
] on
behalf of Black, Michael (IS) [michael.bla...@ngc.com]
Sent: Friday, September 02, 2011 8:00 AM
To: General Discussion of SQLite Database
Subject: EXT :Re: [sqlite] sqlite3_open_v2 performance degrades as number of
opens increase
I assume you've overridden the system default for 1024 files
sers-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on
behalf of Terry Cumaranatunge [cumar...@gmail.com]
Sent: Friday, September 02, 2011 6:30 AM
To: sqlite-users@sqlite.org
Subject: EXT :[sqlite] sqlite3_open_v2 performance degrades as number of opens
increase
Hello,
We have an application
My first thought would be to check the amount of memory being used by
your many connections. Each connection will consume a non-trivial
amount of resources (page cache, file handles, OS file cache, etc.)
It's certainly plausible that your overall system performance is
reduced as you run out of
On 2 Sep 2011, at 12:30pm, Terry Cumaranatunge wrote:
> We have an application that creates many small databases (over 100K) to be
> able to control the size of the database and provide more deterministic
> performance. At process startup, it opens many of these databases in a loop
> to keep
Hello,
We have an application that creates many small databases (over 100K) to be
able to control the size of the database and provide more deterministic
performance. At process startup, it opens many of these databases in a loop
to keep them open for faster transaction response times. The
10 matches
Mail list logo
