hooray!

I timed it at 4 or 5 seconds per page this morning, albeit with only about 180 systems and not many scans or first discovered tags.

That must be the newer data since 1.3 since mine are taking me upwards of a minute per page if not more and assuming I dont crash.
 
I don't want to try to get back on a work night as I am way too tired to concentrate (which is why I explore a lot). I was hoping to get my game face on and come screaming in like a flock of eagles straight into a nice safe dock while I can actually read the screen and not have "QWERTY" imprinted on my forehead :eek:
 
Are they using XML on the server side for data storage too? That would be very inefficient compared even to conventional databases.
I would hope not, as that would be _really_ bad as you point out. Turn on verbose logging and you can see some of the XML that is shooting back and forth.

I honestly have no idea, but would hope they have an object or object-relational system that allows them to only create/populate/update info as needed, and not have all 400 billion systems and associated celestial bodies and other info populated in it (which would be really bad, if not near impossible), based on their random seed algorithm that they use to create a system every time you enter it, which was discussed several times in dev diaries and DDF I believe. Imagine the primary and foreign key indices and stored queries on that very hypothetical fully populated 400 billion record table for "SYSTEM" in a standard relational database, and the SQL and inner and outer joins to be able to do anything, and how long it would take to execute. Would not be pretty. ;-)

While I think it is technically possible to have a table (or tables) with billions of rows, that does not mean it is actually feasible or practical in a live environment.

Anyways, waaaay off topic. My fault.
 
Last edited:
Its an interesting part of ED to me... but then I work in IT. Somewhere they have to have something that says for System X, Planetary Body Y, First Discovered by Z. If every time someone sells data they have to regenerate the system (sector?) from its seed, work out what planetary body Y is (to determine value), check to see if its already been discovered, and then update the discovery as well as the cmdrs own history of discovered/sold systems, balance, explorer rank, etc. I can see why they'd have opportunities for performance improvement.
 
Last edited:
Back
Top Bottom