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
