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 it's own thread, but first increased the stack size to 1024k from the initial 512k, and no difference. > My first (and only) reaction is "bug in your code" overrunning a char buffer. > > If you could show

Re: [sqlite] Virtual Table and the xBestIndex

Hi all, Where can I get an example of xFilter implementation? The issue I am having here is that when I am trying to execute a "select * from tablex where value=1" all I get is the last result from the file (336cc2282716::1). int my_filter( sqlite3_vtab_cursor* pCursor, int idxNum, const char

Re: [sqlite] long insert statement failing on iPhone

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.

Re: [sqlite] Releases?

http://www.sqlite.org/download.html maybe you want the windows/linux pre-compiled libs on that page? On 26 February 2011 16:51, Clay Fowler wrote: > Where and how do we download releases? The site at > http://system.data.sqlite.org/ leads me eventually to open and

[sqlite] Releases?

Where and how do we download releases? The site at http://system.data.sqlite.org/ leads me eventually to open and closed "leaves". Am I supposed to pick one of those? Are there official releases? Thanks! ___ sqlite-users mailing list

Re: [sqlite] COUNT() extremely slow first time!

On 25 Feb 2011, at 10:03pm, Greg Barker wrote: > Thanks for the responses guys. > >> I would never have any table with 150 columns. It should be possible to >> keep the schema for your table in your head. > > Unfortunately those are the cards I have been dealt. The columns are just > buckets

Re: [sqlite] Virtual Table and the xBestIndex

Thank you very much. Now that you cleared that for me I need to look in my code why simple query like "select * from table x" works fine but as soon as I call "select * from table x where value=1" is only returning the last line from the file. Thank you Darek -Original Message- From:

Re: [sqlite] long insert statement failing on iPhone

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?

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 help. Problem is that it could be another statement doing the overrun too so as much code as you could share would help. Michael D. Black Senior Scientist NG

Re: [sqlite] COUNT() extremely slow first time!

Thanks for the responses guys. > I would never have any table with 150 columns. It should be possible to keep the schema for your table in your head. Unfortunately those are the cards I have been dealt. The columns are just buckets of data (bucket1, bucket2, bucket3, etc). Each bucket could be