Hi Stavros, I would not expect MySQL to be slower on any Linux, usually, it is the reverse situation.
Very long query like this one is probably very io intensive, even 3 second is quite long for a query (except for large data set reporting). So I suggest you look at these: - The cpu and io during the fetch. If CPU is low, you are waiting for io. If your mac is running a PCI Express SSD, it is probably way faster than the AWS storage. - Your MySQL server setting for memory caches may differ. - Last and not least, check if your server process is not using more memory than your physical (vm allocation). This would generate memory swapping, thus using io... Unless you are fetching a very large number of rows, I would optimize this query. EOF does not play well with long queries. Regards, Samuel > Le 13 mars 2018 à 09:07, Stavros Panidis <stavros.pani...@gmail.com> a écrit : > > Hi all, > > Recently I tested an app in an AWS Lightsail instance UBUNTU 16.04 server > running MySQL 5.7. > > I realised extremely slow performance running queries, comparing to the same > exactly database running on a Mac OS X High Sierra. For example a query that > is performed within 3 seconds on MAC takes around 3.5 minutes to complete in > UBUNTU. > > Database is SNOMED CT (a large medical terms database downloaded from UMLS). > MySQL version, database structure and indexes are identical in both servers. > > I understand that has nothing to do with WebObjects but does anyone had a > similar experience with MySQL in ubuntu? > > Many thanks in advance > > Stavros Panidis > stavros.pani...@gmail.com <mailto:stavros.pani...@gmail.com> > > > > _______________________________________________ > Do not post admin requests to the list. They will be ignored. > Webobjects-dev mailing list (Webobjectsemail@example.com) > Help/Unsubscribe/Update your Subscription: > https://lists.apple.com/mailman/options/webobjects-dev/samuel%40samkar.com > > This email sent to sam...@samkar.com
_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjectsfirstname.lastname@example.org) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com