Re: Speed on Android

2015-03-22 Thread Pierre Sahores
Jacque, GET and POST are perfectly supported on both iOS and Android. If you send them to an LC server script (connected to the DB in localhost mode), you will no more have to compose with any latency anymore. working example : on the iOS/Android mobile client app side : set the

Re: Speed on Android

2015-03-22 Thread Peter M. Brigham
On Mar 21, 2015, at 2:57 PM, Ralph DiMola wrote: Richard Gaskin wrote: How does LC connect to the database socket on platforms where it provides no socket support? Magic. Any sufficiently advanced technology is indistinguishable from magic. -- Arthur C. Clark -- Peter

RE: Speed on Android

2015-03-22 Thread Ralph DiMola
, March 21, 2015 9:22 PM To: How to use LiveCode Subject: Re: Speed on Android On 3/21/2015 7:34 PM, Ralph DiMola wrote: Brain storm. How about the true I put in the revOpenDatabase after the password, Could this be it? Oh man. That was it. I think I love you. -- Jacqueline Landman Gay

Re: Speed on Android

2015-03-22 Thread J. Landman Gay
On 3/22/2015 8:45 AM, Pierre Sahores wrote: GET and POST are perfectly supported on both iOS and Android. If you send them to an LC server script (connected to the DB in localhost mode), you will no more have to compose with any latency anymore. Thanks Pierre. I'm actually doing that with

Re: Speed on Android

2015-03-22 Thread J. Landman Gay
On 3/22/2015 10:37 AM, Ralph DiMola wrote: It was bugging me. I wasn't going to let it go. For which I am grateful. Thank you for being stubborn. -- Jacqueline Landman Gay | jac...@hyperactivesw.com HyperActive Software | http://www.hyperactivesw.com

Re: Speed on Android

2015-03-21 Thread J. Landman Gay
On 3/21/2015 12:58 AM, Ralph DiMola wrote: I access a remote MySQL db(diesel) when the app starts up. It takes a couple of seconds to do a few reads and writes. I will put a db write inbetween cards and see how long it takes. Here's my new theory. Mobile doesn't support libURL, which is what

RE: Speed on Android

2015-03-21 Thread Ralph DiMola
Jacqueline Landman Gay wrote: Here's my new theory. Mobile doesn't support libURL, which is what handles the connections on desktop. When I ask for a remote connection to a database, something takes over that seems to repeatedly try to connect and times out (10+ secs or so.) In between timeouts I

Re: Speed on Android

2015-03-21 Thread Richard Gaskin
J. Landman Gay wrote: Richard Gaskin wrote: Que a post from Mark Wieder about the benefits of web APIs for DB connectivity in three...two...one... ... ...the conclusion is: remote database connections are not supported. But GET and PUT are. :) Snappy, and more secure than exposing the DB

Re: Speed on Android

2015-03-21 Thread Richard Gaskin
Ralph DiMola wrote: I see what libURL is all about but I don't see what it has to do with opening a MySQL db from an app. All I do is open the dB with a: put revOpenDatabase(mysql, tDatabasePath, DBName ,username ,Password true) into DBID The DB remains open during app execution. I

RE: Speed on Android

2015-03-21 Thread Ralph DiMola
: use-livecode [mailto:use-livecode-boun...@lists.runrev.com] On Behalf Of Richard Gaskin Sent: Saturday, March 21, 2015 2:44 PM To: use-livecode@lists.runrev.com Subject: Re: Speed on Android J. Landman Gay wrote: Richard Gaskin wrote: Que a post from Mark Wieder about the benefits of web APIs

RE: Speed on Android

2015-03-21 Thread Ralph DiMola
Ralph DiMola wrote: Richard Gaskin wrote: How does LC connect to the database socket on platforms where it provides no socket support? Magic. Richard Gaskin wrote: I'm intrigued. Does this magic work on Android as well? I wonder if we can leverage this for other socket comms...

RE: Speed on Android

2015-03-21 Thread Ralph DiMola
Richard Gaskin wrote: How does LC connect to the database socket on platforms where it provides no socket support? Magic. Ralph DiMola IT Director Evergreen Information Services rdim...@evergreeninfo.net ___ use-livecode mailing list

Re: Speed on Android

2015-03-21 Thread J. Landman Gay
On 3/21/2015 1:51 PM, Ralph DiMola wrote: I see what libURL is all about but I don't see what it has to do with opening a MySQL db from an app. The database is on a remote server, so it uses an http URL rather than a file path and requires some method of internet communication. That's

Re: Speed on Android

2015-03-21 Thread J. Landman Gay
On 3/21/2015 2:07 PM, Ralph DiMola wrote: Ralph DiMola wrote: Richard Gaskin wrote: How does LC connect to the database socket on platforms where it provides no socket support? Magic. Richard Gaskin wrote: I'm intrigued. Does this magic work on Android as well? I wonder

Re: Speed on Android

2015-03-21 Thread Mike Bonner
Hmm. I thought you could still get URL blah blah on mobile and it would work. In fact, though the functionality differs slightly, you can use the load command on mobile too. Perhaps this would be useful? If you're using http urls, the only real difference in load between desktop and mobile, is

RE: Speed on Android

2015-03-21 Thread Ralph DiMola
-livecode [mailto:use-livecode-boun...@lists.runrev.com] On Behalf Of J. Landman Gay Sent: Saturday, March 21, 2015 6:04 PM To: How to use LiveCode Subject: Re: Speed on Android On 3/21/2015 1:51 PM, Ralph DiMola wrote: I see what libURL is all about but I don't see what it has to do with opening

Re: Speed on Android

2015-03-21 Thread Mike Bonner
PM To: How to use LiveCode Subject: Re: Speed on Android On 3/21/2015 1:51 PM, Ralph DiMola wrote: I see what libURL is all about but I don't see what it has to do with opening a MySQL db from an app. The database is on a remote server, so it uses an http URL rather than a file path

Re: Speed on Android

2015-03-21 Thread J. Landman Gay
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 nohttp://; Yes, I misspoke. There's no http in the database path, it's like yours: put

Re: Speed on Android

2015-03-21 Thread J. Landman Gay
On 3/21/2015 1:44 PM, Richard Gaskin wrote: J. Landman Gay wrote: Richard Gaskin wrote: Que a post from Mark Wieder about the benefits of web APIs for DB connectivity in three...two...one... ... ...the conclusion is: remote database connections are not supported. But GET and PUT are.

RE: Speed on Android

2015-03-21 Thread Ralph DiMola
[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

RE: Speed on Android

2015-03-21 Thread Ralph DiMola
...@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

Re: Speed on Android

2015-03-21 Thread J. Landman Gay
On 3/21/2015 7:39 PM, Ralph DiMola wrote: Another thing. Could it be your router/firewall? Did you try over the cellular network? If it were my router I think it would fail on my Mac and it works fine there. I can try on a different network though. How about the true I put in the

Re: Speed on Android

2015-03-21 Thread J. Landman Gay
On 3/21/2015 7:34 PM, Ralph DiMola wrote: Brain storm. How about the true I put in the revOpenDatabase after the password, Could this be it? Oh man. That was it. I think I love you. -- Jacqueline Landman Gay | jac...@hyperactivesw.com HyperActive Software |

Re: Speed on Android

2015-03-20 Thread J. Landman Gay
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

Re: Speed on Android

2015-03-20 Thread Ralph DiMola
message /divdivFrom: J. Landman Gay jac...@hyperactivesw.com /divdivDate:03/21/2015 01:40 (GMT-05:00) /divdivTo: How to use LiveCode use-livecode@lists.runrev.com /divdivSubject: Re: Speed on Android /divdiv /divOn 3/20/2015 11:07 PM, Ralph DiMola wrote: I use both SQLite and MySQL

Re: Speed on Android

2015-03-20 Thread J. Landman Gay
On 3/20/2015 11:07 PM, Ralph DiMola wrote: 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

RE: Speed on Android

2015-03-20 Thread Ralph DiMola
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: Friday, March 20, 2015 8:40 PM To: How to use LiveCode Subject: Re: Speed on Android On 3

Speed on Android

2015-03-20 Thread J. Landman Gay
I'm trying to build an Android app. It is taking about 5 seconds to respond to touches, card changes, etc. I started with 7.0.3, then tried in 6.6.7 thinking it might be faster but it's the same. Buttons and list fields are not autohiliting because it takes too long for the app to realize

Re: Speed on Android

2015-03-20 Thread Colin Holgate
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? ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe

RE: Speed on Android

2015-03-20 Thread Ralph DiMola
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: Friday, March 20, 2015 5:20 PM To: LiveCode Mailing List Subject: Speed on Android I'm trying

Re: Speed on Android

2015-03-20 Thread J. Landman Gay
On 3/20/2015 4:20 PM, J. Landman Gay wrote: Any speedup tricks? An addition: the main problem seems to be that it is taking 5-8 seconds to respond to a touch event. After that, scripts run at only slightly slower speeds than desktop. I'm using mouseUp rather than touchEnd. Would that