[sqlite] Minimizing Internal Function Calls in SQLite

2013-07-30 Thread Andrew Beal
Hi All, Is there a way to minimize function calls internal to SQLite? At some points of execution, I have measured as much as 35 deep nested function calls. Since we are running on an embedded system, we don't support such a deep call table. Thanks! Andrew Beal

Re: [sqlite] Minimizing Internal Function Calls in SQLite

2013-07-30 Thread Richard Hipp
On Tue, Jul 30, 2013 at 8:00 AM, Andrew Beal ab...@whoi.edu wrote: Hi All, Is there a way to minimize function calls internal to SQLite? At some points of execution, I have measured as much as 35 deep nested function calls. Since we are running on an embedded system, we don't support such a

Re: [sqlite] Minimizing Internal Function Calls in SQLite

2013-07-30 Thread Howard Chu
Richard Hipp wrote: On Tue, Jul 30, 2013 at 8:00 AM, Andrew Beal ab...@whoi.edu wrote: Hi All, Is there a way to minimize function calls internal to SQLite? At some points of execution, I have measured as much as 35 deep nested function calls. Since we are running on an embedded system, we

Re: [sqlite] Minimizing Internal Function Calls in SQLite

2013-07-30 Thread Andrew Beal
Richard, Thanks for the response. We are using a custom environment without a deep call stack due to specific hardware latency issues. How does the SQLITE_SMALL_STACK option work with the SQLITE_ZERO_MALLOC option? F. Andrew Beal Woods Hole Oceanographic Institution 266 Woods Hole Road MS#18

Re: [sqlite] Minimizing Internal Function Calls in SQLite

2013-07-30 Thread Richard Hipp
On Tue, Jul 30, 2013 at 9:30 AM, Andrew Beal ab...@whoi.edu wrote: Richard, Thanks for the response. We are using a custom environment without a deep call stack due to specific hardware latency issues. Do you have a custom C compiler? Or is there some extant C compiler (that I don't know

Re: [sqlite] Minimizing Internal Function Calls in SQLite

2013-07-30 Thread Andrew Beal
-users-boun...@sqlite.org] On Behalf Of Richard Hipp Sent: Tuesday, July 30, 2013 9:38 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] Minimizing Internal Function Calls in SQLite On Tue, Jul 30, 2013 at 9:30 AM, Andrew Beal ab...@whoi.edu wrote: Richard, Thanks for the response

Re: [sqlite] Minimizing Internal Function Calls in SQLite

2013-07-30 Thread Richard Hipp
On Tue, Jul 30, 2013 at 9:45 AM, Andrew Beal ab...@whoi.edu wrote: Our vendor provided a custom C compiler which is overflowing the stack with the increased depth of the call table which then overflows into other memory. Your description above is ambiguous, but I interpret it to mean that it

Re: [sqlite] Minimizing Internal Function Calls in SQLite

2013-07-30 Thread Andrew Beal
Subject: Re: [sqlite] Minimizing Internal Function Calls in SQLite On Tue, Jul 30, 2013 at 9:45 AM, Andrew Beal ab...@whoi.edu wrote: Our vendor provided a custom C compiler which is overflowing the stack with the increased depth of the call table which then overflows into other memory. Your

Re: [sqlite] Minimizing Internal Function Calls in SQLite

2013-07-30 Thread Warren Young
On 7/30/2013 06:11, Richard Hipp wrote: Wow. What embedded system is it that doesn't support a call stack that is *only* 35 levels deep? The 12-bit PIC microcontrollers are limited to 2-level stacks, and many of the smaller 14-bit PICs are limited to 8-level stacks. Not that I expect that