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 
> <[email protected]>:
> 
> 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 
>> <[email protected]>:
>> 
>> 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 
>>> <[email protected]> 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
>>> [email protected]
>>> 
>>> _______________________________________________
>>> use-livecode mailing list
>>> [email protected]
>>> Please visit this url to subscribe, unsubscribe and manage your 
>>> subscription preferences:
>>> http://lists.runrev.com/mailman/listinfo/use-livecode
>> 
>> 
>> _______________________________________________
>> use-livecode mailing list
>> [email protected]
>> Please visit this url to subscribe, unsubscribe and manage your subscription 
>> preferences:
>> http://lists.runrev.com/mailman/listinfo/use-livecode
> 
> 
> _______________________________________________
> use-livecode mailing list
> [email protected]
> Please visit this url to subscribe, unsubscribe and manage your subscription 
> preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode


_______________________________________________
use-livecode mailing list
[email protected]
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Reply via email to