Not sure why some of my graphs are crashing unpredictably... maybe stack overflows from SQLITE calls or a memory leak from not clearing a bundle? Anyways, I put my SQLITE database and user data on the FTP server so you can play around with the graphs if you want to.. just copy everything from the /data and /databases directories into the /Calorie Confessor or wherever you have your voCal app stored on your phone.
No razzin' me on the crap I still eat though
UPDATE: I am pretty sure most of the crashes were caused by bad FN.RTN's inside of DO-UNTIL loops.... I keep forgetting!
Last edited by cterp2 on Tue Jun 28, 2016 6:01 pm, edited 1 time in total.
I ditched the GR mode keyboard and instead made a simple HTML one... not sure why the bottom row of buttons doesn't line up exactly right but it works well.. No more flickering when switching modes for goal and calorie entries
2016-06-28 18.01.03.png [ 35.76 KiB | Viewed 329 times ]
Hmmm.... I do seem to crash a lot when running memory intensive graphs.. I have gotten a few "Low Memory" warnings and it seems to improve when I replaced the HTML asklist$ menu with a DIALOG.SELECT so I am thinking SQLITE might be eating up space and/or there is some serious glitch in my HTML. I think I'll upgrade my wife's "pink" version and see what happens. Not really sure if the query cursor gets released from memory inside a function. I will see if I can get it to crash on my wife's data.
I did some more benchmarking today and am really not sure that the BYTE.READ is much faster than GRABFILE.. I went back to using GRABFILE for now.
Today I found the source of my graph crashes: I was using SQL.QUERY.LENGTH and a for-next loop instead of the SQL.NEXT done flag with a do-until loop.. Turns out there appears to be a memory leak somewhere with the SQL.QUERY.LENGTH because it would crash the app even if I just called LENGTH without even doing the SQL.NEXT part. Much more stable now..
Users browsing this forum: No registered users and 1 guest
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot post attachments in this forum