Inter-Level Experience Reset - A Possible Solution

[Sighearth]

I mean, yea anyone with minimal programming background knows that in theory should be easy enough. That includes SE, if they are not taking the route of recrawling all the new values its obvious that is something else that we don't know about. And its better we don't know, the little they advertise their infrastructure the better. Now based on wild speculation I think that they will need multiple read and write actions per character ( as any character could have up to 17 battle jobs + all DoH and DoL jobs). Probably its calculated in relation to an exponential curve and that curse will most likely change per expansion (by level interval). My guess is that you would need multiple different calculations per level interval/per job/per character/per something else. SO maybe having to look up some many things would lead to combinatorial explosion. Thinking that solving the problem with hashes/3-4 hours of programming and SE haven't done that because it didn't know better its really naive. They know how to do it its just not worth it.

[Ryvick]

Yar, clearly all they need to do is take a meat cleaver to the end of all the numbers in this game and chop off the last 2 digits from everything. That would be far faster than your lolly-gagging. I'm a butcher by trade so clearly I know the best way to code an MMORPG. Yar!

[Sighearth]

Yar, clearly all they need to do is take a meat cleaver to the end of all the numbers in this game and chop off the last 2 digits from everything. That would be far faster than your lolly-gagging. I'm a butcher by trade so clearly I know the best way to code an MMORPG. Yar!

You, I like you

[DrWho2010]

the solution most likely exists, but is ultimately not worth the doing. easier to take the path of least resistance for something of this nature.

[arathald]

If there’s anything I’ve learned in over a decade working in professional software development, it’s that someone else’s backend is never as simple or clean to worth with as you assume it is from the outside.

[Anonicat]

Also No-SQL is Document Based .... IMAGINE like your character info and everything is stored in document in JSON format would be nice. You can add or remove as you see needed. But that comes at a cost (performance and potentially bug prone if not handled correctly.) Honestly it would be more beneficial to use in MMO's, but not completely. Having to join tables over and over. If its not cached just takes too much time. Also caching takes too much memory. Alot of companies go the route of SQL, which is relational which is fine for the most part... but i don't think all my character data should be stored across multiple tables that seems costly as hell to query, and takes up precious computing time on the servers. I would actually use No-SQL for certain parts of the MMO backend and SQL for other parts (say the data analytics they gather.). I don't know why tbh they don't having to deal with all the joins and stuff is annoying programming, and im almost certain things could be made alot faster if programmers made NoSQL and SQL work together.

Like for example assuming that character data is all relational and items etc.
You have to join the character table on the items table. (Again performance cost.)
Now however that is assuming their is one table for items, and 1 for character. but say they have 10 columns or whatever.. for the individual items they have. They could just pull it from one table. Which would be alright. But if its seperated into rows, oh buddy...

In a NOSQL - SQL hybrid you could be like CharacterItemsEquipped = 1,2,3,4,5,6,7,8,9 (being item indexes) do an SQL QUery where ItemIndex = CharacterItemsEquipped and return the items pretty fast, then it simpler to just update the table of items when a stat squish is needed.

[Floortank]

Maybe it's not a problem worth going out of their way to solve.

[weebtext]

dude just level up lmao

[LariaKirin]

Pointless armchair developer suggestions.
Do you think any of this didn't occur to them? They've decided to do it this way for reasons you do not know.

You should know that it's unwise to propose a solution when you do not know the details of the problem.

[Anonicat]

Pointless armchair developer suggestions.
Do you think any of this didn't occur to them? They've decided to do it this way for reasons you do not know.

You should know that it's unwise to propose a solution when you do not know the details of the problem.

I agree with you to some extent. And I'm just replying to OP's thoughts on it. Second stop with "Armchair X". First we've both worked in software development as a career, so we do have some knowledge on it.

Second you must be of the belief cause some one is a "Senior Software Engineer" as a job 40+ hours a week that they are an expert on said subject. Let me assure you job titles mean jack diddly in the real world. You couldn't be further from the truth my friend. Job titles are just titles to make oneself feel better very rarely do they mean what they should. Now im not saying the Devs at Square Enix are like this at all.. But some people do have actual knowledge in that field and have some insight into.

Also just a side teaser, you know those career professionals you speak so highly about they get hacked all the time by people who aren't employed by said companies. Check out Cyberpunk 2077, or any other. Kinda odd, didn't think those software professionals were able to be touched.. *shrugs*