Re: [sqlite] long insert statement failing on iPhone

2011-02-28 Thread Mickey Mestel
simon, > > The theory is that you are actually doing something wrong in your code, and > this triggers obvious problems on the iPhone itself because the iPhone itself > is so tight on space. However the simulator doesn't uncover these problems > because it has plenty of memory and stack space:

Re: [sqlite] long insert statement failing on iPhone

2011-02-28 Thread Simon Slavin
On 28 Feb 2011, at 5:39pm, Mickey Mestel wrote: > dan, >> >> I've have never tried this. But if I had the problem above, I would. >> >> http://landonf.bikemonkey.org/code/iphone/iPhone_Simulator_Valgrind.20081224.html > > looks interesting, but it doesn't support arm, which is where the

Re: [sqlite] long insert statement failing on iPhone

2011-02-28 Thread Mickey Mestel
dan, > > I've have never tried this. But if I had the problem above, I would. > > > http://landonf.bikemonkey.org/code/iphone/iPhone_Simulator_Valgrind.20081224.html looks interesting, but it doesn't support arm, which is where the problem is showing up. the problem doesn't occur in t

Re: [sqlite] long insert statement failing on iPhone

2011-02-28 Thread Dan Kennedy
On 02/26/2011 09:37 AM, Mickey Mestel wrote: > hi all, > > new to the list. > > we are compiling the sqlite.c amalgamation file into our project, as we > want to encrypt the database, and the sqlite that comes with the iOS sdk does > not allow for that. > > we are developing on

Re: [sqlite] long insert statement failing on iPhone

2011-02-28 Thread Mickey Mestel
michael, just getting into it, but... > Did you increase the main thread size too? i'm sure it's there, but i don't see a way to mess with the stack size on the main thread. docs say that (for a secondary thread, doesn't mention the main thread), that in order to be effecti

Re: [sqlite] long insert statement failing on iPhone

2011-02-28 Thread Black, Michael (IS)
org] on behalf of Mickey Mestel [mmes...@epocrates.com] Sent: Saturday, February 26, 2011 2:11 PM To: General Discussion of SQLite Database Subject: EXT :Re: [sqlite] long insert statement failing on iPhone well, this doesn't seem to be a stack size issue. i put the long insert statement on

Re: [sqlite] long insert statement failing on iPhone

2011-02-26 Thread Mickey Mestel
mation Systems > Advanced Analytics Directorate > > > > > From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on > behalf of Mickey Mestel [mmes...@epocrates.com] > Sent: Friday, February 25, 2011 8:37 PM > To: sqlite-users@sqlite.org > Subject: EXT :

Re: [sqlite] long insert statement failing on iPhone

2011-02-26 Thread Mickey Mestel
michael, > And now my 2nd reaction is potential stack overflow... > > From what I can find IOS has a 1MB stack size for the main thread and 512K > for secondary threads. Mac OS X has an 8MB. > > Are you settting the stack size? the more i think about this, the more i agree. m

Re: [sqlite] long insert statement failing on iPhone

2011-02-26 Thread Black, Michael (IS)
el.bla...@ngc.com] Sent: Saturday, February 26, 2011 7:18 AM To: General Discussion of SQLite Database Subject: EXT :Re: [sqlite] long insert statement failing on iPhone My first (and only) reaction is "bug in your code" overrunning a char buffer. If you could show where you do this maybe we can h

Re: [sqlite] long insert statement failing on iPhone

2011-02-26 Thread Black, Michael (IS)
T :[sqlite] long insert statement failing on iPhone hi all, new to the list. we are compiling the sqlite.c amalgamation file into our project, as we want to encrypt the database, and the sqlite that comes with the iOS sdk does not allow for that. we are developing on iO

[sqlite] long insert statement failing on iPhone

2011-02-25 Thread Mickey Mestel
hi all, new to the list. we are compiling the sqlite.c amalgamation file into our project, as we want to encrypt the database, and the sqlite that comes with the iOS sdk does not allow for that. we are developing on iOS 4.2, and to date have tried 3 different versions