Thread: Best Database Software for RSPS/Runescape?

MySQL only has bad performance when the programmer writing code to use it, or if they are designing it, is ignorant. A database server isn't going to magically go fast.

You'd be amazed at the performance gains one will see when queries are written with even the smallest optimizations

Originally Posted by Graham

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...

ive no idea how hard it would be to replicate such software, all i'm saying is that they do tend to use their own stuff rather than others, which is why i'd guess that they use their own .

Originally Posted by Lmctruck30

In many of videos and press releases they have said many times RedHat

Most likely because it is open source OS

It was a rhetorical question

Originally Posted by Lmctruck30

In many of videos and press releases they have said many times RedHat

Most likely because it is open source OS

i am pretty sure they would be using Redhat for the commercial support they provide for the system instead of the fact it's open source (just like just about every other Linux distribution is also)

Originally Posted by thiefmn6092

i am pretty sure they would be using Redhat for the commercial support they provide for the system instead of the fact it's open source (just like just about every other Linux distribution is also)

Wait so some of their main Servers are Linux based?

Smart people i guess

Originally Posted by thiefmn6092

MySQL only has bad performance when the programmer writing code to use it, or if they are designing it, is ignorant. A database server isn't going to magically go fast.

You'd be amazed at the performance gains one will see when queries are written with even the smallest optimizations

Okay so if i had a simple method which executes a Delete and Insert query, how would i optimize this.

Code:

    public static boolean online(int x) {
        try {
        query("DELETE FROM `online` WHERE id = 1;");
        query("INSERT INTO `online` (id, currentlyonline) VALUES('1','"+x+"');");
        } catch (Exception e) {
            e.printStackTrace();
            return false;
        }
        return true;
    }

The reason i am asking is because i want to know which ways you use to "optimize" your code. Like in my opinion, i think all of the stuff in there is necessary, but i don't understand how you could optimize something like that. Or i might just be really stupid :\

Originally Posted by iLankan

Wait so some of their main Servers are Linux based?

Smart people i guess



Okay so if i had a simple method which executes a Delete and Insert query, how would i optimize this.

Code:

    public static boolean online(int x) {
        try {
        query("DELETE FROM `online` WHERE id = 1;");
        query("INSERT INTO `online` (id, currentlyonline) VALUES('1','"+x+"');");
        } catch (Exception e) {
            e.printStackTrace();
            return false;
        }
        return true;
    }

The reason i am asking is because i want to know which ways you use to "optimize" your code. Like in my opinion, i think all of the stuff in there is necessary, but i don't understand how you could optimize something like that. Or i might just be really stupid :\

I am sure it's safe to say that their servers are not Windows based... and even more so not Solaris based, which pretty much only leaves Linux when it comes to systems with a large commercial support base (FreeBSD has horrid commercial support for that matter)...

As for the query, INSERT is a pretty straight forward query set and doesn't really need changes, it's just important to make sure your have a good table design without queries spanning multiple tables for a single logical result

Originally Posted by thiefmn6092

I am sure it's safe to say that their servers are not Windows based... and even more so not Solaris based, which pretty much only leaves Linux when it comes to systems with a large commercial support base (FreeBSD has horrid commercial support for that matter)...

As for the query, INSERT is a pretty straight forward query set and doesn't really need changes, it's just important to make sure your have a good table design without queries spanning multiple tables for a single logical result

I have different databases for each purpose (Payments, Highscores, Votes, etc..) and on top of that i have different tables in each database. I never knew it would create so much lagg. Now i know, thx