Jump to content
Search In
  • More options...
Find results that contain...
Find results in...

MySql or .INI?


jcsnider
 Share

Recommended Posts

  • 2 weeks later...
MySQL seems pretty pointless for Eclipse. With Eclipse, you host the server on a machine run by you. Using a MySQL database means that when the client asks for data, the server queries the database, then goes back to server, back to client, etc. With binary data, the server already has the info. Simple binary files take out an unneeded connection/query, so it's faster. Since all the server files are stored on your computer anyway, having some pieces of data at another location is far from ideal. It'd be different if this was a browser based game or had multiple servers across many locations that need to access common data.

That said, having data accessible from an online location means you can query it for PHP stat pages, etc.
Link to comment
Share on other sites

If you host the mysql server on the machine hosting the server, speeds are nearly identical to flat files.. A use case for a mysql db would be the ability to login to the server, forums, website with all the same user/pass & have access to all the same data (so on the forums your avatar could be your in game sprite).

Another reason for using a SQL based database is queries.
```
SELECT * FROM USERS WHERE Name LIKE %bob%
```is much cleaner than searching through all the users with the string bob in it.. There's a reason for it, idk if that reason justifies the cost of creating it.
Link to comment
Share on other sites

@Ballie:

> Simple binary files take out an unneeded connection/query, so it's faster. Since all the server files are stored on your computer anyway, having some pieces of data at another location is far from ideal.

I couldn't have said it better myself!
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...