Speed on Android

Ralph DiMola rdimola at evergreeninfo.net
Sat Mar 21 20:39:50 EDT 2015

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

More information about the Use-livecode mailing list