Speed on Android

[Ralph DiMola]

This is perplexing. I just put in a front script for preopencard and log the
current card name to the remote MySQL db(diesel). I just tested it on my
Galaxy S4 and still have sub-second card changes. Highlighting of the
buttons work. The app is still snappy. I checked the db and the log entries
are there. There has to be something we're overlooking here.

Brain storm.....
How about the ",,,,true" I put in the revOpenDatabase after the password,
Could this be it?

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: Saturday, March 21, 2015 6:41 PM
To: How to use LiveCode
Subject: Re: Speed on Android

On 3/21/2015 5:24 PM, Ralph DiMola wrote:
> I just open the remote database like this==> put 
> revOpenDatabase("mysql", "YourDomain.on-rev.com", "DatabaseName" 
> ,"Username" ,"Password" ,,,,true) into DBID
>
> Note there is no"http://"

Yes, I misspoke. There's no "http" in the database path, it's like yours:

   put "accountname.on-rev.com" into tDatabaseAddress
   put "xxx" into tDatabaseName
   put "yyyy" into tDatabaseUser
   put "passwdxx" into tDatabasePassword
   put revOpenDatabase("MySQL", tDatabaseAddress, tDatabaseName,
tDatabaseUser, tDatabasePassword) into tID

I get an ID back. When I issue commands, I also get database data back. 
Then I have to wait 10-15 seconds until the app unfreezes.

Every database call in the scripts is surrounded by a command to open the
database, get data, close the database. It used to not always close the
connection, but I added all the closures to see if it would help. 
Neither way makes any difference.

I shouldn't have said "http", I should have said "sockets". I think what's
happening is a socket timeout. Even though LC says there is no socket
support on mobile, there must be something under the hood if it is
communicating with a server.

-- 
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