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
    • Our Partners
    • Issue Tracker
  • Pilot's Lounge
    • Academy Graduates
    • Online Events
    • Flight Tours
    • Forums
  • Our People
    • Join Us
    • Pilot Roster
    • Pilot Locations
    • View Logbooks
    • Pilot Accomplishments
    • Century Club
  • ACARS
    • Live ACARS Map
    • Google Earth
    • ACARS Flights
    • Dispatch Schedule
    • Top Dispatchers
  • Statistics
    • Airline Totals
    • Flight Statistics
    • Online 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
Airlines Air France Virtual, Delta Virtual Airlines
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 v12.1) Copyright © 2004 - 2025 Global Virtual Airlines Group. All Rights Reserved. (Build 961)
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.