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 rdim...@evergreeninfo.net -----Original Message----- From: use-livecode [mailto:use-livecode-boun...@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 | 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