[Release] Fastest MySql System [C#]

[Spirited42]

Removed.

Why do you think?
Is it really THAT shocking to you that I removed it?

[.Ryu]

=O Good job gareth

[Spirited42]

#Updated.
I included my MySql Reader too.
This is my full mysql system.

#request thread name change to:
"[Release] Fastest MySql System [C#]"

Thanks. =]
Sincerely,
Spirited.

[Huseby]

Done.

[Spirited42]

Nobody has anything to say about this? .-.
Can I improve on anything in this?

[Korvacs]

Eh, this isnt really that fastest method to query mysql nowadays, you need to be using stored procedures really.

[.Ryu]

Originally Posted by Korvacs

Eh, this isnt really that fastest method to query mysql nowadays, you need to be using stored procedures really.

Your such a downer huh? You can't just say thanks and be on with it lol

[Santa]

Originally Posted by .Ryu

Your such a downer huh? You can't just say thanks and be on with it lol

Its called constructive criticism. If you cannot take it then your choosing the wrong "hobby" or profession. Nobody gets better if nobody tells them its wrong.

[Spirited42]

Originally Posted by StarBucks

Its called constructive criticism. If you cannot take it then your choosing the wrong "hobby" or profession. Nobody gets better if nobody tells them its wrong.

You're right. That's actually what I was looking for actually by releasing this. I really do need advice with coding. Well, hope you guys use it well. I'm going to look up what stored procedures are.

EDIT: Wooaahhh... that's really different. .-. I've never seen anything like that. It seems powerful but very challenging... hmm... maybe I should look at other sites besides Wikipedia.

[Korvacs]

Originally Posted by .Ryu

Your such a downer huh? You can't just say thanks and be on with it lol

Well, the rest of it is good, just that the string based query isnt as fast as a stored procedure which moves alot of the work you may want to do with the data onto the mysql server and returns a more precise data set, or allows you to do less handling of data on the game server and more on the mysql server.

They are faster and more powerful than string based queries, but your right i should just keep these sort of improvements to myself and let you guys, the community, flounder around using out dated methods...

[.Ryu]

Originally Posted by Korvacs

Well, the rest of it is good, just that the string based query isnt as fast as a stored procedure which moves alot of the work you may want to do with the data onto the mysql server and returns a more precise data set, or allows you to do less handling of data on the game server and more on the mysql server.

They are faster and more powerful than string based queries, but your right i should just keep these sort of improvements to myself and let you guys, the community, flounder around using out dated methods...

Is this the stored procedure you might be talking about?
I'm looking into and came across this

using System;

using System.Collections.Generic;

using System.Data;

using MySql.Data.MySqlClient;

using System.Configuration;

using System.ComponentModel;

 

[DataObject(true)]

public static class MessagesDB

{

    private static string GetConnectionString()

    {

        return ConfigurationManager.ConnectionStrings

            ["MySQLConnectionString"].ConnectionString;

    }

 

    [DataObjectMethod(DataObjectMethodType.Select)]

    public static List<MessageItem> GetMessages()

    {

        MySqlCommand cmd = new MySqlCommand("ShowAll", new MySqlConnection(GetConnectionString()));

        cmd.CommandType = CommandType.StoredProcedure;

        cmd.Connection.Open();

        MySqlDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);

 

        List<MessageItem> MessageItemlist = new List<MessageItem>();

        while (dr.Read())

        {

            MessageItem MessageItem = new MessageItem();

            MessageItem.Entry_ID = Convert.ToInt32(dr["Entry_ID"]);

            MessageItem.Message = Convert.ToString(dr["Message"]);

            MessageItem.Name = Convert.ToString(dr["Name"]);

            MessageItem.Email = Convert.ToString(dr["Email"]);

            MessageItemlist.Add(MessageItem);

        }

        dr.Close();

        return MessageItemlist;

    }

 

    [DataObjectMethod(DataObjectMethodType.Insert)]

    public static void InsertMessage(MessageItem MessageItem)

    {

        MySqlCommand cmd = new MySqlCommand("InsertMessage", new MySqlConnection(GetConnectionString()));

        cmd.CommandType = CommandType.StoredProcedure;

        cmd.Parameters.Add(new MySqlParameter("param1", MessageItem.Name));

        cmd.Parameters.Add(new MySqlParameter("param2", MessageItem.Email));

        cmd.Parameters.Add(new MySqlParameter("param3", MessageItem.Message));

        cmd.Connection.Open();

        cmd.ExecuteNonQuery();

        cmd.Connection.Close();

    }

 

    [DataObjectMethod(DataObjectMethodType.Update)]

    public static int UpdateMessage(MessageItem MessageItem)

    {

        MySqlCommand cmd = new MySqlCommand("UpdateMessage", new MySqlConnection(GetConnectionString()));

        cmd.CommandType = CommandType.StoredProcedure;

        cmd.Parameters.Add(new MySqlParameter("paramkey", MessageItem.Entry_ID));

        cmd.Parameters.Add(new MySqlParameter("param1", MessageItem.Name));

        cmd.Parameters.Add(new MySqlParameter("param2", MessageItem.Email));

        cmd.Parameters.Add(new MySqlParameter("param3", MessageItem.Message));

        cmd.Connection.Open();

        int i = cmd.ExecuteNonQuery();

        cmd.Connection.Close();

        return i;

    }

 

    [DataObjectMethod(DataObjectMethodType.Delete)]

    public static int DeleteMessage(MessageItem MessageItem)

    {

        MySqlCommand cmd = new MySqlCommand("DeleteMessage", new MySqlConnection(GetConnectionString()));

        cmd.CommandType = CommandType.StoredProcedure;

        cmd.Parameters.Add(new MySqlParameter("param1", MessageItem.Entry_ID));

        cmd.Connection.Open();

        int i = cmd.ExecuteNonQuery();

        cmd.Connection.Close();

        return i;

    }

 

}

I would just post the link but i'm not quite sure it's allowed.

#Edit
Well...here is something else i found



Or even this



Is this what your talking about i'm not sure i quite get it yet

[Korvacs]

Yes those are examples of using stored procedures, one of the important parts is that you only need send the variables to the server instead of the entire string, and then the mysql server does all of the rest of the work, you obviously need to write the rest of the handling on the mysql server.

My fusionorigins source and cuosp source both use stored procedures.

[.Ryu]

Originally Posted by Korvacs

Yes those are examples of using stored procedures, one of the important parts is that you only need send the variables to the server instead of the entire string, and then the mysql server does all of the rest of the work, you obviously need to write the rest of the handling on the mysql server.

My fusionorigins source and cuosp source both use stored procedures.

Oh i see =O i will download your source to check it out then thanks

[5supertao]

Unlike you do for me I'll say. Good job, atleast your learning and not leaching. Even if things aren't the BEST. YOU can't be the best without practice. Good job.

[drakejoe67]

Thanks, hopefully this might make a difference in my SQL handler and my SQL problems could dissapear, well a step
thx