Air France / KLM Virtual Airlines

  • Our Airline
    • Home
    • Login
    • NOTAMs
    • Airline News
    • Fleet Gallery
    • Image Gallery
    • Le Ciel Entre Nous
    • Online Flights
    • Logged In Users
    • Issue Tracker
  • Pilot's Lounge
    • Academy Graduates
    • Online Events
    • Forums
  • Our People
    • Join Us
    • Pilot Roster
    • Pilot Locations
    • Pilot Accomplishments
    • Century Club
    • View Logbooks
  • ACARS
    • Live ACARS Map
    • Google Earth
    • ACARS Flights
    • Dispatch Schedule
    • ACARS Track Map
    • Top Dispatchers
  • Statistics
    • Airline Totals
    • Flight Statistics
    • Simulator Versions
    • Passenger Statistics
    • Landing Statistics
    • Optimal Landings
    • Server Statistics
  • Contact Us
    • Corporate Offices
    • Our Staff
    • Password Reset
    • Privacy Policy
    • Career Opportunities
DEVELOPMENT ISSUE #5,257 - Refactor GetGates
Reported by Luke Kolin (DVA043) on 08/19/2019 10:49 ET
Assigned To Luke Kolin (DVA043)
Issue Status Fixed on 09/14/2019 09:36 ET
Issue Priority Medium
Security Public
Area ACARS
Issue Type Enhancement
Target Version 8.6
Issue Description GetGates is causing slow PIREP filing. Refactor to use a cache, and run an explain select on the query.

Database MySQL acars.gatedata select 90.8 10.0 3,800
Java org.deltava.acars.workers.LogicProcessor$CommandWorker.run() 3.4 0.714 144
Database MySQL dva.pilots select 2.9 1.43 123
Java other 0.8 0.286 34
Database MySQL afv.pilots select 0.5 0.277 19.2
ISSUE COMMENTS
THERE ARE NO COMMENTS FOR THIS ISSUE.
 

Air France Virtual Airlines 2006 (Golgotha v8.7) Copyright © 2004 - 2020 Global Virtual Airlines Group. All Rights Reserved. (Build 727)
For flight simulation purposes only. Not a commercial website. In no way are we affiliated with Air France, KLM Royal Dutch Airlines, their affiliates or any other airline. All logos, images, and trademarks remain the property of their respective owners. Air France / KLM Virtual is a non-profit entity engaged in providing an avenue for flight simulation enthusiasts.