Hi Griggs,
Many thanks for your reply. The question I have is how/by how much one must
adjust these limits (in a rather optimal way) for a given, specific real
machine.
Best regards,
Ha
--- On Wed, 2/4/09, Griggs, Donald <donald.gri...@allscripts.com> wrote:
From: Griggs, Donald <donald.gri...@allscripts.com>
Subject: RE: [sqlite] Limits in SQLite
To: haquan...@yahoo.com, "General Discussion of SQLite Database"
<sqlite-users@sqlite.org>
Date: Wednesday, February 4, 2009, 10:53 AM
Greetings, Ha Le,
When you asked "What are the factors which determine the different
limits", I suspect I'm not understanding just what you're asking.
You referenced
http://www.sqlite.org/limits.html
And one of your two examples was "Maximum Depth Of An Expression
Tree"
The webpage reports:
==============================
Maximum Depth Of An Expression Tree
... The depth of expression trees is therefore limited in order to avoid using
too much stack space.
The SQLITE_MAX_EXPR_DEPTH parameter determines the maximum expression tree
depth. If the value is 0, then no limit is enforced. The current implementation
has a default value of 1000.
=============================
All software running on real machines has limits. Most of the limits in
sqlite are so high that if one is approaching them, there's a fairly good
chance one's design is not going to work well with sqlite anyway.
The tree depth explanation from the webpage describes why the depth is limited,
plus it lets you increase or decrease the default maximum as your needs dictate.
The default of 1000 is quite high.
What further information were you looking for?
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
