Jump to content

All Activity

This stream auto-updates

  1. Last week
  2. Honestly... beta.4 ? It is almost 3 years old and how on earth are you able to use Dispo Basic with it, I never tested my addons with beta.4 and they were never designed to work properly with it Are you really on beta.4 or it was just a typo If this is not a typo, I would kindly and urgently advise to upgrade to at least beta.5 (I would say latest dev, but beta.5 is ok too), with module and themes being updated of course. Best wishes,
  3. Debugbar itself adds some more time to the process, but it is nice to see the queries being run. Considering that the flights page is paginated and loads up maybe max 20 flights, how you ended up 112 queries is strange. Are you using an addon theme or default theme (not altered, pure default)? Are you using any modules being loaded at flights page, any custom widgets etc.? Why asking this, because I saw some addon themes loading up models in blades, doing direct database queries in loops, for some eye candy stuff which are already provided by v7 internally mostly. Example; I am using a custom theme, my airport details page loads up 4 additional widgets including a flights map, checking LTFM which has 600 inbound / 600 outbound flights and lots of pireps, page loads up fine in 2-3 seconds max, not something like your EHAM. Airport Details Page; (+4 widgets) Flights Page; (+2 widgets) Profile Page; (+40 widgets or more, did not counted them one by one) All above pages do load around 3 seconds max, as an example the last one (profile) was loaded in 2.28 seconds including the debugbar's own load and time loses. In a live server where it is not being called, my results are much nicer. Some of the duplicated queries are from the widgets placed (Aircraft, Pilots, Flight Reports, Personal Stats, Maps etc), they may be a single widget being loaded several times with different configurations to get different data, so some of their db queries are same/duplicated etc. Anyway, if you can provide some more info maybe we can talk about possible solutions / improvements.
  4. JGK

    Extremely slow loading

    Thanks for your reply. PHPVMS version 7.0.0-beta.4 Experiencing the issues both on a local development environment as on a vps. I have installed DisposableBasic Further all default.
  5. What exact latest version are you using? Beta 5 or the latest Dev version from the #v7-releases channel on Discord? Who is the host? Shared, VPN, other? All default or any addon themes or modules?
  6. JGK

    Extremely slow loading

    in the meantime i was able to reduce the airports table down to 2700 airports and reduced the flights table down to 3000 flights, still extreme loading times, up to 32 seconds for an airport like Amsterdam with 500 inbound and 500 outbound flights. Running the latest version of phpvms, php 8.1 and mariaDB.
  7. Hiya! An issue I've encountered with my phpVMS-based website. We're experiencing significant loading times, often between 10 to 15 seconds, which we believe is impacting user experience negatively. Our database is quite extensive, containing around 16,000 flights. Upon investigating the issue using Laravel Debugbar, we discovered that a large number of duplicated SQL statements are being executed. Here's a brief overview of what we're seeing: Total statements executed when loading the flights page: 112 (85 of which are duplicates, 27 unique) Example duplicated query: select 'name', 'enabled' from 'modules' (This is executed multiple times for different module names.) Loading times for the 'GET flights' request: Approximately 6.53 seconds We have tried to optimize our database and application code as much as possible but are still facing these high loading times due to the duplicated queries. I'm looking for any advice or strategies you might have for dealing with these issues. Specifically, I'm interested in ways to reduce these duplicated statements and optimize the overall performance of the application. Here are some questions I have: Are there known best practices within the phpVMS community for optimizing large databases and reducing query duplication? Has anyone else experienced similar performance issues, and if so, how were you able to resolve them? Are there any specific tools or plugins recommended for analyzing and optimizing performance in a phpVMS setup? Any insights, experiences, or recommendations would be greatly appreciated. I'm eager to learn from the community and find effective solutions to improve our site's performance. Regards! Joost
  8. Hello... just an FYI your contact e-mail on the website returns to sender as well. I sent you a DM, if you are still providing VA services, please let me know. Thanks a ton.
  9. Earlier
  10. Good afternoon everyone, My name is Gary and am in the process of starting up a new VA called SplitJet. At the start, I'll be focusing on Corporate Charters within the United States with the intent of expanding to Europe. I started my first VA back in 1998, called SoCal Airways and was providing ATC with SATCO in the early days, then VATSIM later on. Over time, life took me away from FS, but when MSFS2020 was announced, I knew I would have to get back into the hobby. Over the past year, I've built a home cockpit and with the advances of MSFS, I'm back for the long haul. So came the idea of starting up a new VA, so here I am. I am hoping to find someone who might be super duper familiar with phpVMS and and work with me as I learn. Anyone with paint skills. Those are high priority positions. Later, I'd like to find anyone who thinks they could head up the European division. Over time, I think I can do this myself, but I do enjoy working with like minded individuals who enjoy aviation as much as I do. Website is still be built, and the crew page is currently being setup, but if you think you want to chat more about this, shoot me a DM, or feel free to join the discord. https://discord.gg/R9gcF5tH Thank you all for your time. Gary
  11. As long as you can run a webserver on a device and fulfill server requirements, it can run... It does not require a specific hardware on the server, of course more cpu power and ram assigned to the servers will give you a better performance during runtime. Disk space depends on specially the database size, files on the server (phpvms v7, themes, modules etc) will not need that much space (say maybe max 100 mb for them), rest will be database space (which will be dynamic as you can imagine). If you did run apache, php8, mariadb etc. on your Raspberry device before, why not doing the same for v7 and start testing Basic requirements are listed here Good luck
  12. Hi all, I am looking at the possibility of starting a VA using phpVMS (looks really good!). Is it possible and/or productive to run the software on a Raspberry Pi 4B? I have been able to run applications on it before like Apache2, MariaDB, php, WordPress, etc etc. I am not sure though if phpVMS has any other specific machine requirements. I wouldn't expect to be hosting a huge VA or even permanent on a Pi. But somewhere to start until such time an upgrade may be needed. (EDIT: another question. how much mass storage is ideal, either RP4 or a "normal" computer? How much storage expansion could I potentially expect to use overtime with PIREPs being stored?) Thanks! 😄
  13. Why are you adding a new airport for an already existing real airport with a new non-standard (fake) icao code ? This is the main question. Just add LECH to your phpvms v7 database, either by lookup or manually then you can start using it with vmsAcars too. Good luck
  14. i added a new custom airport Calamocha LECH from MS2020. Actually, LECH already exist so i gave icao LECH1. When i select it on ACARS i get an error " Error prefiling. " VaCentral/VaCentral::getAirport(): Return value must be of type VaCentral/Models\Airport, none returned". Can you help to solve it?
  15. Translate as expected, nothing more... Check other folders (like de, fr, it, es-es) and replicate what is done there for your language That simple it is. Good luck and God speed
  16. Is there any way to create your own language? For example: Hungarian? I saw the lang folder but what exactly do I have to do there?
  17. Why wondering, just do it and do it as much as you want and whenever you want. Critical values are always saved in internal units (like pirep distances, weights, fuel etc) What you see at admin settings are for display only, like displaying the distances in km or displaying the fuel values in kg etc. Not for database operations. Enjoy
  18. Hi all, We have just started an airline and went with pounds and dollars to begin with because it made everything straightforward. We're considering switching to kilograms and euros though - and wondered if anybody else has switched - and what was involved. I'm guessing we would need to take the airline offline while doing it, and run some queries to convert all of the weights, rates, etc across all of the affected tables. As I said - wondering if anybody else has already done it in the past.
  19. I kindly asked you the version you are running/using one week ago, and that had a reason In early builds we had a bug in that duplicate check and it was skipping some flights, latest build is ok. Both import and admin area uses same duplicate checks, which allows more flexibility for schedule planning. If you are not on the latest dev yet, consider updating your v7 and try again, it may help. Also check your logs for any clues about import problems, skips etc. Good luck
  20. Is it possible that the flights table check for duplicates only comparing flight number, dep icao, arri icao, and subfleet? If that is the case, is it possible to have it include route code, leg, and dep time as well as arrival times?
  21. Never mind - just realised how > artisan phpvms recalculate-stats
  22. Just looking through the source code, there is a dev console with a raft of really useful commands (such as re-calculating stats) - I'm wondering if anybody has ever used it - and if so how?
  23. Did you checked the log (for errors or notes during import) ? Which version you are on ? Did you checked the database (via phpMyAdmin or similar workbench tool) ? It is possible that some of those flights may be skipped (or updated). Latest dev build allows more flexibility during imports and duplicate checks (which will result an update instead of an insert on old versions like beta.5 or earlier) Hope this helps, good luck
  24. I recently imported 4000 flights via admin/flights/imports. Only 3250 can be seen. What will cause the difference? What is the permiters or specifics that the import system uses to compare routes? Duplicate flights have been removed and all flights are marked as active prior to import on cvs exported from admin/flights/export. All flights are marked as visible. Thanks in advance for any assistance.
  25. Great news, we added that IATA code usage for testing but it is not finalized yet, so for now (until further notice) keep using ICAO codes Later on it will be possible to use IATA codes as like real airlines.
  26. So i went into my database and KPVD was marked correctly, but i went into my flights .csv and found that KPVD was labeled as just PVD. After changing both the inbound and outbound flight to reflect KPVD the import went through successfully.
  27. @Vangelis Hi, I'm encountering this issue when trying to load the plugin - Any suggestions please?
  1. Load more activity
×
×
  • Create New...