On 2014/07/03 14:05, Simon Slavin wrote:
On 3 Jul 2014, at 8:47am, Hick Gunter wrote:
This function is already available in the sqlite3 C interface.
I did not understand that at all. I have never needed to look at that
statement. But yes, it does allow you to find out if there are any ope
On 3 Jul 2014, at 8:47am, Hick Gunter wrote:
> This function is already available in the sqlite3 C interface.
I did not understand that at all. I have never needed to look at that
statement. But yes, it does allow you to find out if there are any open
statements for a database. Thanks.
Ho
On Wed, 02 Jul 2014 17:03:43 +0100, Grzegorz Sikorski
wrote:
> Hi Hick,
>
> You were right I was not finalizing statements and this prevented close
> to complete. When I modified my code to finalize all statements before
> close it works fine.
>
> However I was always checking return status fro
eneral Discussion of SQLite Database
Betreff: Re: [sqlite] Problem with many connections
On 3 Jul 2014, at 8:24am, Hick Gunter wrote:
> How about this?
>
>
> sqlite3_stmt *sqlite3_next_stmt(sqlite3 *pDb, sqlite3_stmt *pStmt);
>
> This interface returns a pointer to the next prepar
On 3 Jul 2014, at 8:24am, Hick Gunter wrote:
> How about this?
>
>
> sqlite3_stmt *sqlite3_next_stmt(sqlite3 *pDb, sqlite3_stmt *pStmt);
>
> This interface returns a pointer to the next prepared statement after pStmt
> associated with the database connection pDb. If pStmt is NULL then this
.
-Ursprüngliche Nachricht-
Von: Simon Slavin [mailto:slav...@bigfraud.org]
Gesendet: Mittwoch, 02. Juli 2014 18:18
An: General Discussion of SQLite Database
Betreff: Re: [sqlite] Problem with many connections
On 2 Jul 2014, at 5:03pm, Grzegorz Sikorski wrote:
> I admit I had missed this sente
Grzegorz Sikorski wrote:
> Hi Hick,
>
> You were right I was not finalizing statements and this prevented close to
> complete. When I modified my code to finalize all statements before close it
> works fine.
This implies that you have not checked your application with
valgrind which would have f
On Wed, 2 Jul 2014 17:18:23 +0100
Simon Slavin wrote:
> I hope SQLite4 changes this and if there are statements still open
> either returns an error code or automatically closes any open
> statements. Or both.
Me too. I can't think of any other application I use that doesn't free
all resources
On Wed, 02 Jul 2014 15:50:58 +0100
Grzegorz Sikorski wrote:
> > 1020 simultaneus connections? Perhaps iOS exhausted del max. file
> > descriptor per process.
> 1020 is the number of open operations. Number of connections opened
> at the same time is much lower (2-3).
If your connections use ORDE
On 2 Jul 2014, at 5:03pm, Grzegorz Sikorski wrote:
> I admit I had missed this sentence, but to be honest, it seems to be very
> confusing behaviour.
I'm glad you have found the problem.
It's not good and I don't think this is a good way to handle things. I hope
SQLite4 changes this and if
Is
there a lsof command or a /proc filesystem or equivalent?
-Ursprüngliche Nachricht-
Von: Grzegorz Sikorski [mailto:g.sikor...@kelvatek.com]
Gesendet: Mittwoch, 02. Juli 2014 13:02
An: sqlite-users@sqlite.org
Betreff: [sqlite] Problem with many connections
Hi,
I am not sure if my previo
eturn status, thus missing SQLite having a lot of open files. Is
there a lsof command or a /proc filesystem or equivalent?
-Ursprüngliche Nachricht-
Von: Grzegorz Sikorski [mailto:g.sikor...@kelvatek.com]
Gesendet: Mittwoch, 02. Juli 2014 13:02
An: sqlite-users@sqlite.org
Betreff: [sqlit
Eduardo Morras wrote:
> On Wed, 02 Jul 2014 12:02:27 +0100
> Grzegorz Sikorski wrote:
>
>> Hi,
>>
>> I am not sure if my previous email had reached the list, so I just
>> repeat it:
>>
>> I am developing sharding database using SQLite3 for embedded
>> application. My code works fine up to about
On 02/07/14 15:41, Eduardo Morras wrote:
On Wed, 02 Jul 2014 12:02:27 +0100
Grzegorz Sikorski wrote:
Hi,
I am not sure if my previous email had reached the list, so I just
repeat it:
I am developing sharding database using SQLite3 for embedded
application. My code works fine up to about 1020
On 2 Jul 2014, at 1:00pm, Grzegorz Sikorski wrote:
> On 02/07/14 12:20, Simon Slavin wrote:
>> On 2 Jul 2014, at 12:02pm, Grzegorz Sikorski wrote:
>>
>>> My code works fine up to about 1020 connections to the database. After
>>> around this number, I get an error "unable to open database file
On Wed, 02 Jul 2014 12:02:27 +0100
Grzegorz Sikorski wrote:
> Hi,
>
> I am not sure if my previous email had reached the list, so I just
> repeat it:
>
> I am developing sharding database using SQLite3 for embedded
> application. My code works fine up to about 1020 connections to the
> database
On 02/07/14 12:20, Simon Slavin wrote:
On 2 Jul 2014, at 12:02pm, Grzegorz Sikorski wrote:
My code works fine up to about 1020 connections to the database. After around this
number, I get an error "unable to open database file". [snip]
This should not happen. But I don't know why it would h
On 2 Jul 2014, at 12:02pm, Grzegorz Sikorski wrote:
> My code works fine up to about 1020 connections to the database. After around
> this number, I get an error "unable to open database file". [snip]
This should not happen. But I don't know why it would happen. I have seen
individual apps
Hi,
I am not sure if my previous email had reached the list, so I just repeat it:
I am developing sharding database using SQLite3 for embedded application. My code works
fine up to about 1020 connections to the database. After around this number, I get an
error "unable to open database file".
19 matches
Mail list logo