I've tried my hardest to replicate this. And failed. Any info on what happened before this would be appreciated
I've tried my hardest to replicate this. And failed. Any info on what happened before this would be appreciated
If its stuck checking databases the most likely thing is that the index's in SQLLite got corrupted and its rebuilding, or SQLLite is doing housekeeping ..
That can really leave the DB in a crapped up state, the kind of problems you've had earlier. Some writes to the DB have not been committed properly if you force a shutdown before it's ready.Can this be due to closing the app incorrectly? I usually click the X, answer yes & then wait until it closes before closing down the machine. However I guess if time is short & I’m in a hurry occasionally I click the X a second time & it then seems to finish quicker. I’m guessing this was the cause of the problem?
I see this as well. I'm using the portable version. Could that be a contributor?2) The column sizing is a strange one. I've tried a lot, randomly resizing, minimizing, etc to cause it to mess up. But never caught it in the act. It must be sometimes that the save routine gets called with the column sizes changed, but i can't reproduce it.
I wonder if there is one of those cases of the main thread exiting while background threads are still in flight: https://stackoverflow.com/questions/9555948/what-happens-to-the-main-thread-in-this-case.1) it is best to wait for the program to close down properly, since we need to terminate SQLite transactions in a manner which means the database is okay. If you use the normal close mechanism it should be okay. You can't speed up the closedown hitting x again.
...
I could believe a background thread issue since sometimes the app closes down almost immediately while sometimes it seems to take 5 minutes; at which point I usually go off & feed the copawlot & ship’s cat, but sometimes I’m in a hurry. Is there a way to force the outstanding updates to complete as a matter of urgency in a future update?
Edit: or is the close/“ok” dialog the quick way of closing?![]()
I'm trying to get to know EDDiscovery but I have a couple of queries, and would be grateful for guidance.
EDDiscovery seems to eat an awful lot of my drive capacity and RAM. I'm running Windows 10 on a laptop with 8GB RAM, an 8th gen Core i7 CPU and a GTX 1050 GPU. I can't run it in the background while playing ED because it takes up too much processing power and the game constantly stutters. Does anyone have any suggestions in how to avoid this?
Also, at the bottom of the EDDiscovery window it says "EDSM Star database updated" with an ever-growing number. Each time I open EDDiscovery this starts at zero but even after 24 hours of leaving the app open it keeps going. When I try to close EDDiscovery I get the message "EDDiscovery is updating the EDSM and EDDB databases, Press OK to close now, Cancel to wait until update is complete".
So I'm wondering, exactly what is being updated (e.g. is the data direction from EDD to EDSM, or from EDSM to EDD?), how long does that process of updating take, and is it normal for it to take that long every time I open the programme?
(sorry if I'm asking in the wrong place...)
Coni
EDDiscovery seems to eat an awful lot of my drive capacity and RAM. I'm running Windows 10 on a laptop with 8GB RAM, an 8th gen Core i7 CPU and a GTX 1050 GPU. I can't run it in the background while playing ED because it takes up too much processing power and the game constantly stutters. Does anyone have any suggestions in how to avoid this?
Hmmm... My internet connection is very fast, and I've left the update running on its own, but after 14 hours that file is 9GB in size and is still growing...It's downloading the systems in EDSM for local maps, route plotting etc. How long that will take depends on your internet connection and whether the database is being written to an SSD or HDD, the database will be almost 4GB when it's done and can be found at "C:\Users\<you>\AppData\Local\EDDiscovery\EDDSystem.sqlite" by default.
Thank you very much Eahlstan, your translation is spot on and I've set the priority to below normal, but don't notice a difference - its still crunching much more of the SSD than other processes. Maybe its just a bad install. I might try deleting and reinstalling the software.The newest version made changes to the multithreading of the DB. This is the reason why EDD now can take up a high percentage of your CPU power. There is only one way to prevent this from happening at the moment: Open your task manager (ctrl+shift+esc) and switch to the 'details' tab. Search for EDDiscovery.exe and right click on it, open the 'priority' menu and lower it to something lower than 'normal' (sorry if this is named something different in english I'm just translating it on the fly).
This way EDD will just use CPU power that's realy unused, which should eliminate your lags. This has to be done every time EDD is started, in the next update there will be an option to automatically lower EDD's priority.
Hi iain666, many thanks for your reply.
Hmmm... My internet connection is very fast, and I've left the update running on its own, but after 14 hours that file is 9GB in size and is still growing...![]()