Re: [sqlite] What stack size is required for SQLite to spin?

2011-04-22 Thread Mikael
2011/4/22 Richard Hipp > I do not believe any of these things have any impact on stack depth. But > you should probably double-check by running the experiment. Ok. > Please let us > know if you find me wrong. Yes. Thank you a lot! Kind regards and happy holidays, Mikael

Re: [sqlite] What stack size is required for SQLite to spin?

2011-04-22 Thread Richard Hipp
On Fri, Apr 22, 2011 at 9:05 AM, Mikael wrote: > Dear Richard, > > If by recursion you mean a subselect or alike, then the SQL queries we have > are of a constant recursion level, generally 0 and 4 or so at max, in any > dynamically generated query. Also the depth counted

Re: [sqlite] What stack size is required for SQLite to spin?

2011-04-22 Thread Mikael
Dear Richard, If by recursion you mean a subselect or alike, then the SQL queries we have are of a constant recursion level, generally 0 and 4 or so at max, in any dynamically generated query. Also the depth counted in parentheses of WHERE expressions is constant, 5 or so at max. What varies in

Re: [sqlite] What stack size is required for SQLite to spin?

2011-04-22 Thread Richard Hipp
On Fri, Apr 22, 2011 at 8:17 AM, Mikael wrote: > Aha great. > > Is 12KB the amount of stack space needed on any x64 platform upon unlimited > use (i.e. whatever size and complexity of SQL queries, whatever dataset/DB > size etc.) with the default configuration/installation?

Re: [sqlite] What stack size is required for SQLite to spin?

2011-04-22 Thread Mikael
Aha great. Is 12KB the amount of stack space needed on any x64 platform upon unlimited use (i.e. whatever size and complexity of SQL queries, whatever dataset/DB size etc.) with the default configuration/installation? If not, is there any particular stack size that you would consider a 'safe'

Re: [sqlite] What stack size is required for SQLite to spin?

2011-03-28 Thread Richard Hipp
On Mon, Mar 28, 2011 at 5:25 AM, Mikael wrote: > Hi, > > I'm looking at the possibility of using SQLite in an environment with a > fixed-size stack, and wish to know, what stack size do I need for SQLite > always to work? > We have heard of people running SQLite in as

[sqlite] What stack size is required for SQLite to spin?

2011-03-28 Thread Mikael
Hi, I'm looking at the possibility of using SQLite in an environment with a fixed-size stack, and wish to know, what stack size do I need for SQLite always to work? Obviously I want it to be as small as possible, as I want as much RAM to be available for other purposes as possible. The