Re: Windows Slowness

2020-03-17 Thread matthias rebbe via use-livecode
Bob, but did you already try to use ODBC driver instead of built-in. It´s just a little change in the source code. Maybe the built-in MySQL driver for Win is causing it. Matthias - Matthias Rebbe Life Is Too Short For Boring Code > Am 17.03.2020 um 15:54 schrieb Bob Sneidar via use-livecod

Re: Windows Slowness

2020-03-17 Thread Bob Sneidar via use-livecode
No bother at all! I am using 9.5.1 RC1. I'm not going to 9.6 yet because it's still in developer preview, and I am constantly making changes to a production application, but if this issue has been addressed in 9.6 I will definitely test against it. Bob S > On Mar 16, 2020, at 16:41 , matthi

Re: Windows Slowness

2020-03-16 Thread matthias rebbe via use-livecode
I don´t want to bother you, but may i ask which LC version is used? Or doesn´t that matter and this slowness is noticeable with all LC 9.x releases? My Windows standalone was built with LC 9.5.0. I have other standalones running on the same VM which are built with LC 9.6dp2 and which are also v

Re: Windows Slowness

2020-03-16 Thread Bob Sneidar via use-livecode
Hi Matthias. Well I was pointing out that the same dataset returned on a Mac takes 3 seconds, so the windows fetch returns the same data over 4 times slower, and this is consistent no matter the Windows system I am using. I also have techs in the field that use the app, and it is painfully slo

Re: Windows Slowness

2020-03-16 Thread matthias rebbe via use-livecode
Bob, the data which is returned by MySQL server is how much in size/lines/items per line? Do you use an ip address or the hostname in the connections settings for your MySQL Server? Is it possible, that IP6 is enabled on your Windows machine? If so, did you try to disable it or is IP6 needed?

Re: Windows Slowness

2020-03-16 Thread Bob Sneidar via use-livecode
I tried with 3 different computers, all came back with the same times. 2 were VMs, Parallels and VMWare, and the third was a standalone workstation with AV disabled. It was also the server that mySQL is running on. :-) Bob S > On Mar 16, 2020, at 12:37 , Mark Wieder via use-livecode > wrote:

Re: Windows Slowness

2020-03-16 Thread Mark Wieder via use-livecode
On 3/16/20 11:37 AM, Paul Dupuis via use-livecode wrote: Most time my Windows 10 laptop slows LC (IDE or SA) down it is due to some other process chewing up time. This is Off Topic, but does any know of a safe, reliable tool that will look at all the processes you see when you bring up the Tas

Re: Windows Slowness

2020-03-16 Thread Paul Dupuis via use-livecode
On 3/16/2020 2:27 PM, Richard Gaskin via use-livecode wrote: Bob Sneidar wrote: > Not complaining just reporting. The same standalone on a Mac takes 3 > seconds to load all the data from a series of sql queries. The same > information on Windows standalone takes 13 seconds, both 32 bit and 64 > b

Re: Windows Slowness

2020-03-16 Thread Richard Gaskin via use-livecode
Bob Sneidar wrote: > Not complaining just reporting. The same standalone on a Mac takes 3 > seconds to load all the data from a series of sql queries. The same > information on Windows standalone takes 13 seconds, both 32 bit and 64 > bit, and irregardless of whether or not it is running in a VM.

Windows Slowness

2020-03-16 Thread Bob Sneidar via use-livecode
Not complaining just reporting. The same standalone on a Mac takes 3 seconds to load all the data from a series of sql queries. The same information on Windows standalone takes 13 seconds, both 32 bit and 64 bit, and irregardless of whether or not it is running in a VM. It's just windows network