Speed on Android

[Ralph DiMola]

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
rdimola at evergreeninfo.net


-----Original Message-----
From: use-livecode [mailto:use-livecode-bounces at 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         |     jacque at hyperactivesw.com
HyperActive Software           |     http://www.hyperactivesw.com

_______________________________________________
use-livecode mailing list
use-livecode at lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode