Another thing. Could it be your router/firewall? Did you try over the cellular network? I also open the DB once and let the socket close when the app exits I never issue an explicit close.
==>Image of Ralph grasping at straws. Ralph DiMola IT Director Evergreen Information Services [email protected] -----Original Message----- From: use-livecode [mailto:[email protected]] 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 | [email protected] HyperActive Software | http://www.hyperactivesw.com _______________________________________________ use-livecode mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode _______________________________________________ use-livecode mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
