Re: [sqlite] Maximum number of precompiled queries

2005-04-25 Thread D. Richard Hipp
On Tue, 2005-04-26 at 11:56 +0930, Jake Skinner wrote:
> Does anyone know if there is a maximum number of precompiled queries you
> can attach to a database? 

There is no arbitrary limit.  You can have as many precompiled
statements as you have memory to store them in.
-- 
D. Richard Hipp <[EMAIL PROTECTED]>



[sqlite] Maximum number of precompiled queries

2005-04-25 Thread Jake Skinner
Hello all,

Does anyone know if there is a maximum number of precompiled queries you
can attach to a database? I only ask as some of my precompiled queries
are not working (ie nothing happens to the database, but no errors are
reported), however if I just execute the same SQL query, everything
works as expected.

It is only happening on one table at the moment, but I can't see
anything different or incorrect and the operations I am attempting are
very simple insert, select and delete queries.

Thanks
a confused jake :)