Windows Slowness

Tue Mar 17 11:54:22 EDT 2020

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-livecode <use-livecode at lists.runrev.com>:
> 
> 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 , matthias rebbe via use-livecode <use-livecode at lists.runrev.com> wrote:
>> 
>> 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 very fast when fetching other data from the same MSSQL server.
>> I have currently no MySQL DB available, so i cannot try here.
>> 
>> Another thought. You are connecting using the built-in driver MySQL driver, right? Did you try also to connect using an ODBC driver?
>> https://downloads.mysql.com/archives/c-odbc/
>> Who knows, maybe that makes a difference.
>> 
>> -
>> Matthias Rebbe
>> Life Is Too Short For Boring Code
>> 
>>> Am 16.03.2020 um 23:17 schrieb matthias rebbe via use-livecode <use-livecode at lists.runrev.com>:
>>> 
>>> 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?
>>> 
>>> 
>>> I am running an LC standalone under Win10 64bit in a HyperV VM which connects to MSSQL server using ODBC to fetch 5 price lists.
>>> The returned data per price list is about 800kb and contains about 3000 lines with 16 items per line.
>>> The standalone fetches the 5 different price lists one after the other, which means it fetches 5 times that amount of data described above.
>>> 
>>> It takes here between 4 and 7 seconds to fetch all 5 price lists although AV + Firewall (F-Secure Client Security) is enabled.
>>> 
>>> 
>>> -
>>> Matthias Rebbe
>>> Life Is Too Short For Boring Code
>>> 
>>>> Am 16.03.2020 um 22:11 schrieb Bob Sneidar via use-livecode <use-livecode at lists.runrev.com>:
>>>> 
>>>> 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 <use-livecode at lists.runrev.com> wrote:
>>>>> 
>>>>> 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 Task Manager and help you figure out what you really and need and what you don't?
>>>>> 
>>>>> Yep - Project Lasso...
>>>>> 
>>>>> https://bitsum.com/
>>>>> 
>>>>> -- 
>>>>> Mark Wieder
>>>>> ahsoftware at gmail.com
>>>>> 
>>>>> _______________________________________________
>>>>> use-livecode mailing list
>>>>> use-livecode at lists.runrev.com
>>>>> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
>>>>> http://lists.runrev.com/mailman/listinfo/use-livecode
>>>> 
>>>> 
>>>> _______________________________________________
>>>> use-livecode mailing list
>>>> use-livecode at lists.runrev.com
>>>> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
>>>> http://lists.runrev.com/mailman/listinfo/use-livecode
>>> 
>>> 
>>> _______________________________________________
>>> use-livecode mailing list
>>> use-livecode at lists.runrev.com
>>> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
>>> http://lists.runrev.com/mailman/listinfo/use-livecode
>> 
>> 
> 
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode