FAI-CIVL / FAI-Airscore

AirScore - online paragliding / hanggliding GAP-based scoring software.
https://airscore.cc/
GNU General Public License v3.0
13 stars 17 forks source link

has DB process changed? #164

Closed kuaka closed 3 years ago

kuaka commented 3 years ago

development branch seems a lot (2x) slower than previously when querying the DB.

Has something changed or just a coincidence?

biuti commented 3 years ago

In row.save_or_update() https://github.com/FAI-CIVL/FAI-Airscore/commit/98d1029feca0751488affdae8c573834095a4c72 and in row.from_obj() https://github.com/FAI-CIVL/FAI-Airscore/commit/b5e7d5044eb4146ab6bd51d95a5816093fef4b8a we needed to add a check on db that row with given key exists, so we make one access more, but I don't think this should make a huge difference.