userev at canelasoftware.com
Sat Mar 30 23:40:18 CDT 2013
On Mar 30, 2013, at 12:28 PM, John Allijn <jallijn at gmail.com> wrote:
> I'm working on a windows application that relies a lot on database qeuries. Both reading and writing of data.
> On the server side I use php scripts.
> In my application I use syntax like "Put URL tURL into tResult".
> It all works well, but I am the only user on the database.
> I am wondering what happens when lots of people (about a thousand) use this app. Will livecode wait until the php script is finished? Should there be some error handling on time-outs? If so, what is the best way to do that?
Posting data to a php script is blocking. But, it only takes milliseconds to do the transaction, so it will feel very light. You can have your php script echo data back to you based on success or failure from its point of view. That echo data will be placed into the variable you are putting into.
You can then decide what to to based on the contents of that variable.
More information about the use-livecode