Very bad performance for macOS Tree Merging

specify / specify6

Source Code for Specify 6, Biological Collections Management Platform

https://specifysoftware.org

GNU General Public License v2.0

14 stars 6 forks source link

Very bad performance for macOS Tree Merging #525

Open maxpatiiuk opened 4 years ago

maxpatiiuk commented 4 years ago

Trees in Specify generally have poor performance. But tree merging in macOS is especially bad.

It is about 6 times slover than the equivalent machine with the same settings in Windows 10

Happens with both MySQL 5.7 and MariaDB 10.4 and Auditing On/Off in macOS 10.14 and 10.15 with Biology and KU Fish database

Video: Screen Recording 2020-01-08 at 11.49.30 AM.mov.zip

See also #432

timo11 commented 4 years ago

I don't see any difference in performance between mac (10.13.6, sun java 1.8) and fedora (30, openjdk 1.8) when logged in to the same db (kufishlogtest) on bimysql.nhm.ku.edu. Merging Atheriniformes into Anguilliformes takes about a minute on on both systems. Merging United States into Panama takes 10 seconds on both systems.

Nearly all the time is consumed by the tree structure update that is performed after the merge.

maxpatiiuk commented 4 years ago

I have just tried it in macOS 10.13 and it works just fine Seems that this bug happenes only in macOS 10.14 and 10.15

timo11 commented 4 years ago

I don't have any performance problems running the merges described in my most recent comment when using macOS 10.14. Merges seem slightly faster than with 10.13.

maxpatiiuk commented 4 years ago

Here is the console log: