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
