So for networking on LAN, should I expose the MySQL database to the network or should I wrap it with the client java program, so all requests for data go through the client of the user that started the game?

My plan was to use and sqlite db for local storage (Maybe H2 after I look into it).  When the game starts load the data from the sqlite db into the MySQL db and then broadcast the port number of the MySQL database over the lan so requests can bypass the java program. 

Therefore, each client will have to parse its data requests on its own.  Each client will send data directly to the database instead of through the client of the user that started the game.  Will that be fast enough over LAN or should I always wrap my databases with a client or even not use a database and store everything in the memory of the client?  Thanks for your help.

Just for my curiosity, is there a standard protocol to utilize the processing and graphics power of all the computers connected to the LAN, so that the client of the user that started the game will not have to do all the heavy AI/Economy background code.  Thx.

Thanks.  My chief focus is getting something substantial on my resume.  I already know a lot of C++.  I just think C++ is a pain, so I would rather do Java if feasible.  I just want to make sure that my strategy could work.

Hello.  I've been programming Java for 5+ years.  Mostly low level and student stuff.  I've made a Parcheesi Game and a Side Scroller.  I took a computer graphics class in OpenGl and am thinking about starting a 3D game.  I was thinking of doing a game like KOTOR (Knights of the Old Republic).  Obviously not as long or with as good graphics to start.  I would like to stay with Java, but I've read that C++ is the industry standard and this is a game I would like to put on my resume.  I was planning on focusing on procedurally creating quests that would tie into the main quest.  I was wondering if my java implementation would be fast enough to maintain a pretty hefty background processing.  I was planning on using SQLite for the local storage (and MySQL if it ever goes co-op), JOGL, JOAL, and LUA.


Convince me that doing this Java implementation is feasible and a good idea, and I shouldn't jump ship and use C++.  Go!