Best Database Software for RSPS/Runescape?

Database software can be very helpful to the RSPS community, if utilized properly.

I have tried to use MySQL for many different functions. It serves its purpose up till a certain point. For example, for donation system and vote commands where it doesn't run constant queries, it works fine.

However, the issue is when you want to run constant queries, such as Player Saving so that another world can use it or World Updating, or even just logging information to a database. Functions run A LOT of queries and you need efficient database software for it.

Does anyone have any suggestions other than MySQL (Included in XAMPP). Do we have any idea on what Runescape uses?

I believe Runescape uses the MySQL database system as well.

Quote:

---

Originally Posted by Chief [Only registered and activated users can see links. Click Here To Register...]

I believe Runescape uses the MySQL database system as well.

---

I HIGHLY doubt that, they are a professional company, they are not going to use free software to build their game. Let alone the fact that it is very vulnerable and buggy, all in all, low quality.

Quote:

---

Originally Posted by iLankan [Only registered and activated users can see links. Click Here To Register...]

I HIGHLY doubt that, they are a professional company, they are not going to use free software to build their game. Let alone the fact that it is very vulnerable and buggy, all in all, low quality.

---

Java is free and they use that... your argument is a poor one.

As for your original question:

Which table engine are you using? InnoDB, MyISAM, or something else?

On Emps we had been using InnoDB but yesterday we switched to MyISAM which is much more efficient. With InnoDB we were frequently maxing out the disk reading as much data as we could, but with MyISAM we haven't gone above 20% yet:

[Only registered and activated users can see links. Click Here To Register...]

We have several very large tables:

- 3.3 million rows in the bank items table
- 430,000 rows in the accounts table
- 5.1 million rows in the inventory items table
- 0.5 million rows in the equipment table
- 1.1 million rows in the friends table
- 180,000 rows in the highscores table
- 0.9 million rows in the skills table

Overall the database has 1.5 GB of data within it. Also we send around 40 queries to it per second.

And since the switch we haven't had any issues. It can save all the data of online players (around 700 when we did it) in less than a second (which is pretty good considering it's probably updating hundreds of thousands of rows). The highscores even work well which I'm surprised about since they use this ugly, nested query which isn't amazingly efficient.

MySQL is good if you can structure your database and queries properly. If you do it in a crappy way (e.g. having columns for each item to the point where you have hundreds of columns, keep closing and opening connections to the server, don't use prepared statements/the batch functionality in JDBC, don't use indices/keys properly (that is VERY important), etc) then of course it'll be bad. But it'll be bad whatever database system you try.

tldr; MySQL is good enough for even a large private server - you just need to learn how to use it properly.

Quote:

---

Originally Posted by Chief [Only registered and activated users can see links. Click Here To Register...]

I believe Runescape uses the MySQL database system as well.

---

they would use their own in-house software

Quote:

---

Originally Posted by Scu11 [Only registered and activated users can see links. Click Here To Register...]

they would use their own in-house software

---

How can you be so sure of that?

Quote:

---

Originally Posted by Graham [Only registered and activated users can see links. Click Here To Register...]

How can you be so sure of that?

---

because they use their own inhouse software for many other things regardless of releases similar to their product. they've spoken publicly before about desiging the majority of their content in-house, so I see no reason that they would not make their own database system built around their own needs rather than using an already released system.

Quote:

---

Originally Posted by Scu11 [Only registered and activated users can see links. Click Here To Register...]

because they use their own inhouse software for many other things regardless of releases similar to their product. they've spoken publicly before about desiging the majority of their content in-house, so I see no reason that they would not make their own database system built around their own needs rather than using an already released system.

---

They could have built their own database for saving bank, inventory, items, etc...
but the system would be 'like' all those other database systems in the end.

So there isn't really a use of creating your own database system, if you use an
already existing database system properly.

Quote:

---

Originally Posted by Scu11 [Only registered and activated users can see links. Click Here To Register...]

because they use their own inhouse software for many other things regardless of releases similar to their product. they've spoken publicly before about desiging the majority of their content in-house, so I see no reason that they would not make their own database system built around their own needs rather than using an already released system.

---

Do you think they use their own operating system to run RS servers? Almost certainly not.

A database server which provided the same level of functionality as something like MySQL would also be quite a complex project like the above example which I can't see them doing...

@Graham

I know Java is free, but i meant to say they probably have their own software to handle that stuff.

Anyways, thank you for your ideas and input.
Do you think that it would be easy to use InoDB or MyISAM? Like would i have to learn it on my own or is it user friendly and related to MySQL in a way?