Java Synchronisation

Hygiliak · Post by **Hygiliak** » 09 May 2011, 18:07

Hello There.
In order to properly synchronise acces to central data structures I did a brutal serialisation that I don't know if I can sustain under heavy load.
I synchronised my three concurrent threads (Extension Handler, Event Manager and Task Scheduler) on the same Lock. Therefore, when wither one of those is active, the others have to wait. Will the fact that all three threads make SQL calls have a negative impact on overall performance under heavy load?
Is this setup safe for a turn based game of approximately 1000 concurrent users?

BigFIsh · Post by **BigFIsh** » 10 May 2011, 07:52

These articles may interest you:

SQL locks: http://www.sql.org/sql-database/postgre ... -lock.html

Thread safety with mySQL: http://dev.mysql.com/doc/refman/5.0/en/ ... ients.html

Database multi-threading: http://download.oracle.com/javase/1.3/d ... rame9.html

Hygiliak · Post by **Hygiliak** » 10 May 2011, 12:13

Thanks for the tips.
I will make a dedicated thread that will handle sql commands, so the three threads will no longer have to wait for responses from the SQL server.
In this situation, can my Single Lock strategy for the three threads create problems in the long run?