J, Geez... I was talking about a much more subtle slowdown. From sub .5 second to sub-second performance. I use both SQLite and MySQL in Android apps. There are background images, resizing going on and local SQLite DB access to build scrolling lists of hundreds of lines in sub-second card changes after touching a button. Even orientation changes with resizing are sub-second. Must be something in your dev environment. I just build one today using this Dev Environment:
Testing on a Galaxy S4 Win XP SP3 LC 6.7.3 JDK 1.6.0_31 Android: SDK Tools 23.0.5 Platform-tools 21 Build-tools 22.1.1 Ralph DiMola IT Director Evergreen Information Services rdim...@evergreeninfo.net -----Original Message----- From: use-livecode [mailto:use-livecode-boun...@lists.runrev.com] On Behalf Of J. Landman Gay Sent: Friday, March 20, 2015 8:40 PM To: How to use LiveCode Subject: Re: Speed on Android On 3/20/2015 4:52 PM, Colin Holgate wrote: > Is there a very simple test stack you can make that shows the delay? > Does it make a difference if you use touch events instead of mouse > events? Okay, I've narrowed it down to the database drivers or libraries. If I create an apk without any database inclusions, everything is snappy and runs great. I get some database connection errors in my scripts which is to be expected, but reaction to touch events is instant and card changes are fast. Then I recompile with the database driver (mySQL) and database library and bam. By the clock, 14 seconds from a mouseDown to script execution. What has me puzzled is that this happens on every button, every touch, every card, regardless of whether or not it uses database calls. For example, a button with only a single line of script "go card xxx" has the same delay. On a card with nothing but a list field, a tapped line takes 15 seconds to recognize the tap and hilite. So something about the database is blocking everything else. I haven't worked with it before so I don't know what. Are there some techniques I should be using, like closing connections at a certain time or something else? The stack works fine on desktop, btw. -- Jacqueline Landman Gay | jac...@hyperactivesw.com HyperActive Software | http://www.hyperactivesw.com _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode