Re: LC Server - MySQL - update about 2000 rows/records of a table

2017-12-30 Thread Sannyasin Brahmanathaswami via use-livecode
Ditto what Mike said: " On mysql.. can't you prebuild your multi-command transaction in a variable" I periodically do this kind of thing. assuming the transaction is exactly the same… one way is to build a single SQL query from your data. Assume you need something like this, getting and SQL q

Re: Optimizing for small Android devices

2017-12-30 Thread J. Landman Gay via use-livecode
On 12/30/17 2:44 PM, Sannyasin Brahmanathaswami via use-livecode wrote: I think we need to wait until HQ weighs in on my bug report. Regardless of the fact that it works on iOS and Oreo, one has to wonder how on earth we can close a stack which is set to destroy on close, turn acceleratedRender

Re: Dissolve/Transitions Very Costly

2017-12-30 Thread J. Landman Gay via use-livecode
On 12/30/17 4:06 PM, Sannyasin Brahmanathaswami via use-livecode wrote: # theoretically 1/5 of 2000 = 400 milliseconds why is the script profiler saying this line takes 4765 milliseconds top execute? If it's like the MC profiler, these are relative times. They aren't meant to tell you exactly

Re: Dissolve/Transitions Very Costly

2017-12-30 Thread Tore Nilsen via use-livecode
It may also help to lock the screen for visual effect within a given rectangle, thereby reducing the number of pixels that need to be updated. If the images are of equal dimensions and with the same loc, you can refer to the rect of one of them, otherwise you can have an invisible graphic as ref

Re: Optimizing for small Android devices

2017-12-30 Thread Sannyasin Brahmanathaswami via use-livecode
Reading this in depth. yes, reallocation of bit map space is beyond the developer's realm… I spotted this too… RGB 565… Anyone using this and getting smaller files sizes ver current jpgs? I'm not seeing this as an option in Photoshop on Mac. How we reduced our Android app’s memory

Re: Dissolve/Transitions Very Costly

2017-12-30 Thread Sannyasin Brahmanathaswami via use-livecode
So: if the effectRate defaults to 2000 (which is what I'm seeing here on desktop) and you have -- Show image "grand-canyon" with visual effect dissolve very fast --- # theoretically 1/5 of 2000 = 400 milliseconds why is the script profiler saying this line takes 4765 milliseconds top exec

Re: Optimizing for small Android devices

2017-12-30 Thread Sannyasin Brahmanathaswami via use-livecode
This looks very useful . I think we need to wait until HQ weighs in on my bug report. Regardless of the fact that it works on iOS and Oreo, one has to wonder how on earth we can close a stack which is set to destroy on close, turn acceleratedRendering to false (assume previously cached control

reset waitdepth when idle

2017-12-30 Thread Mike Kerner via use-livecode
Is there a way to reset the waitDepth when nothing is happening? I am running a CRON-type setup. I fire events on a schedule, provided that the waitDepth <=1. Even when LC is idle and nothing is actually waiting, SOMETIMES the waitDepth can be >1, and seeing that, my CRON event never fires the n

Re: Optimizing for small Android devices

2017-12-30 Thread J. Landman Gay via use-livecode
Worth reading just to find out about the 57 MB app memory limit. -- Jacqueline Landman Gay | jac...@hyperactivesw.com HyperActive Software | http://www.hyperactivesw.com On December 29, 2017 9:54:34 PM Richard Gaskin via use-livecode wrote: While looking for one o

Re: LC Server - MySQL - update about 2000 rows/records of a table

2017-12-30 Thread Mark Schonewille via use-livecode
The shell function can do this. I don't know if there could be a limit to the length of the shell command though. Working example: on mouseUp put shortfilepath("C:\Program Files\MySQL\MySQL Server 5.6\bin\mysql.exe") into myFilePath -- the following line contains 2 insert commands pu