Jump to content

Recommended Posts

Posted
28 minutes ago, Elfocrash said:

Let's see for how long

heh.

don't forget that i am stand alone, all those years  i had no help from you or from someone else who know how to programming,(i am not talking about my team) "the outer circle" ,i will be glad if someone else (including you) will help. :) as you know this is my hobby i am not doing it for money. 

Posted
13 hours ago, Tryskell said:

It's never bad to get some competition, so good luck. I hope those 3 "lost" years will translate to a boost of quality.

Thanks, alrthrough I would suggest you to update acis to that if you did not update it yet: https://app.assembla.com/spaces/l2hellas/subversion/commits/508

 

Posted (edited)
5 minutes ago, Nightw0lf said:

Thanks, alrthrough I would suggest you to update acis to that if you did not update it yet: https://app.assembla.com/spaces/l2hellas/subversion/commits/508

 

 

No reason to use 6 when there is 8, and if it's edited, it would be with the ConnectionPooler (= L2DatabaseFactory).

 

If you make a WORKING combo HikariCp + mysql connector, I commit it. It's not the connector which will boost performances.

Edited by Tryskell
Posted (edited)
2 hours ago, Tryskell said:

 

No reason to use 6 when there is 8, and if it's edited, it would be with the ConnectionPooler (= L2DatabaseFactory).

 

If you make a WORKING combo HikariCp + mysql connector, I commit it.

I have a hikari cp/mysqlconnector 5 patch from 2015 but internet says hikari is unstable i did not test it with 6 or later, here take a look

 

Edit to reply on your edit

2 hours ago, Tryskell said:

It's not the connector which will boost performances.

Actually theoretically is (this is the reason I tried to test hikari in this patch), asside the code and how much you use it if the base is "crap" everything works with the "crap", I am not sure how many classes use database connections in a project, but lets say 40% of total classes most of them are on server load so lets take this out of the performance so the communications with the database after server load will be 5% of total project classes this 5% is crucial for server stability and response to clients so it might look small but it will boost every server/client interaction of every client, what do you think about that?

From my tests back in the days late 2014 I noticed big performance difference with HDD ofc (now on SSD its just milisecs), talking about player actions that cause the use of database, with timings sometimes reach 1-3 seconds for lagging but 0.3 and 0.2 msecs less was what I had achieved with live version of hellas and the test version via local network (stupid but wire and wireless tests), to sum up I think the connector can boost performances.

Edited by Nightw0lf
Posted
2 hours ago, Tryskell said:

It's not the connector which will boost performances.

Well this is just wrong. Ofc the connector can boost performance in multiple ways.

Posted (edited)
2 hours ago, Tryskell said:

Make some graphs and come back later.

Don't need to. It's just facts. Libraries can have performance improvements by definition. I'm not saying this specific one has them, but it's undeniable they it can have them. It also means that performance can actually be worse after an update for various reasons, even though this is unusual.

Edited by Elfocrash
Posted
1 hour ago, Kara` said:

Hikari is problematic as fuck i replaced it in my older freya project after 3 hours of usage. There is no performance at all since SQL is already way too fast.

https://github.com/brettwooldridge/HikariCP/wiki/"My-benchmark-doesn't-show-a-difference."

Posted
6 hours ago, Elfocrash said:

So basically the inner-configuration is well structured in Hikari and it doesn't create a flood. In terms of speed there is no huge difference to switch right away as i can see.

Posted (edited)
5 minutes ago, Kara` said:

So basically the inner-configuration is well structured in Hikari and it doesn't create a flood. In terms of speed there is no huge difference to switch right away as i can see.

If that's what you understood, I can't help you. At this point it is known that Hikari is the way to go in terms of connection management and performance with Tomcat JDBC being a close second. c3p0 is considered legacy software, it's not really maintained actively anymore and everybody who's doing something serious in the industry has moved away from it.

 

On the other hand l2j is not considered something serious so c3p0 is good enough, because nobody really knows much about data in here.

Edited by Elfocrash
Posted
2 minutes ago, Elfocrash said:

If that's what you understood, I can't help you. At this point it is known that Hikari is the way to go in terms of connection management and performance with Tomcat JDBC being a close second. c3p0 is considered legacy software, it's not really maintained actively anymore and everybody who's doing something serious in the industry has moved away from it.

 

On the other hand l2j is not considered something serious so c3p0 is good enough, because nobody really knows much about data in here.

We said the same thing using different words. Seem like hikari is the way to go in terms of management of connection but speaking of speed the difference is small i don't see why you wrote "if thats what you understood". I didn't say it's trash i said back when i tried it, it had many problems. (in 2016 or so i can't remember exactly) and i didn't notice any difference. Maybe i didn't knew for the con handling performance and i just tried to compare speed.

Guest
This topic is now closed to further replies.



  • Posts

    • I assume you're some kind of Rito Games player too, right? If so, I've got some bad news for you. We've been reversing their stuff for years, and the VGK driver collects far more information from your PC than you could imagine.   I won't leak or discuss any specifics here for obvious reasons, but if you've played on certain "serious" projects, they may also have something running on your system. Whether it's mining your GPU or doing other shady things, the point is that you can't really say you're completely safe in today's gaming world. 😄 EAC, BE, Vanguard, FACEIT, and pretty much any kernel level anticheat have extremely deep access to your system.   In the wrong hands, that level of access can become a serious privacy risk. If you have the knowledge, dump the game and take a look for yourself. You might be surprised by what's actually going on behind the scenes.   No wonder the VGK team decided to remove the driver from startup and switch to an on demand approach. I guess the exposure became too much of a risk for them to ignore, so they had to make changes to protect their reputation and keep their image clean.   So let's get to the point. Any anticheat for Lineage 2, whether it's considered good or bad, comes with the same issue: if someone wants to compromise your privacy, they can potentially do it because you don't truly know what you're launching or what kind of drivers it installs or loads. TL;DR: Without proper knowledge and analysis, you can't really know what's happening behind the scenes. Cheers.   Let me remind some people who may have forgotten about this. Many years ago, there was a project called BeyondWorld H5. I saw people complaining that their systems became extremely laggy and their GPUs were overheating after running the game for a long time. After further analysis, we found that the client was heavily using the GPU in a way that appeared to be mining related. The point is that nothing is impossible  if someone has enough access and knowledge, many things can happen.
    • I said I'd buy it for my player, I didn't say I would run it on my pc. 
    • Hi there! I am starting to develop my server and I am looking for a professional interface editor. I already have a client and I would like to hire somebody to edit it for me or to offer their own interfaces. I have looked around but all the pre-made interfaces out there, so far, has not pleased me and I what I need for my server. So if you are a professional interface maker, please let me know! Thank you!
    • Thanks FunBasec, I recommend this developer ! He is very friendly and professional.
    • The project is a change to original l2 with modern game mechanics that is more "western". For example every race can craft, not just dwarves. Mages can cast spells without the need of a dedicated box MP charger. MP chargers are also able to solo farm and deal decent damage on their own. Paladins are now 2h sword dedicated healers/support dps. Drop rates are normalized among all classes, no longer needing spoil to craft.   The idea of the project is keep true to the old vanilla classic experience where you are rewarded for effort. And you must put effort into achieving things. Leveling is slow, gear wont be given to you, you must work towards obtaining upgrades. etc.   These are only a small portion of changes I am making to the game. I would love help and bounce design ideas off of others for some future content update ideas. Like can we design unique raid boss encounters? How about end-game content ideas? How can we make owning castles valuable? Maybe an instanced underground mining zone? Or unique raid fights that the clan can do for extra loot?    There's tons of ideas I have and I would like some help creating them.    This is not a paid project. It is a passion project with people who have a passion for l2 and wanna see the community grow.    Currently using client 418. 
  • Topics

×
×
  • Create New...

Important Information

This community uses essential cookies to function properly. Non-essential cookies and third-party services are used only with your consent. Read our Privacy Policy and We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue..