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