I would not expect MySQL to be slower on any Linux, usually, it is the reverse
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
- 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
Unless you are fetching a very large number of rows, I would optimize this
EOF does not play well with long queries.
> 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
> 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 (Webobjectsfirstname.lastname@example.org)
> Help/Unsubscribe/Update your Subscription:
> This email sent to sam...@samkar.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:
This email sent to arch...@mail-archive.com