.net mysql connector performance

[John Adams]

It's the (other) PHP one You can ignore my C# editor haha. I should just delete it.

[Gilraak]

I always liked the idea of a stand-alone exe, but you're right... why re-do what has already been done? Have you seen my DB Editor 2.0 yet? It's just a shell, but I think Steve modeled his editor after it to help move towards a more solid editor for public usage.

That about sums up what I am aiming for. (:

Speaking of which, I need to get ahold of ref and get back to work with him. I was busy this past holiday but its a new year which means new content!

[Scatman]

Very weird. I'm almost bothered by it since I've used the .NET mysql connectors numerous times and never had any issues. If you want to send me your source I'll run it on my PC and see if I get the same results. It'll be easier to debug than communicating over the forums.

[reefcrazed]

I reverted back, and killed what I had. No worry man. There was nothing special to look at anyway.

Part of it was what you said, opening and closing the connection. I think the rest is just latency.

[Gilraak]

I reverted back, and killed what I had. No worry man. There was nothing special to look at anyway.

Part of it was what you said, opening and closing the connection. I think the rest is just latency.

Do you know how to write presistant mysql connections? That may solve any future problems. I also think thats what Scat may have said too.

[reefcrazed]

Well maybe, maybe I know it as something different. Can you elaborate ?

[Gilraak]

Establishes a persistent connection to a MySQL server.

mysql_pconnect() acts very much like mysql_connect() with two major differences.

First, when connecting, the function would first try to find a (persistent) link that's already open with the same host, username and password. If one is found, an identifier for it will be returned instead of opening a new connection.

Second, the connection to the SQL server will not be closed when the execution of the script ends. Instead, the link will remain open for future use (mysql_close() will not close links established by mysql_pconnect()).

This type of link is therefore called 'persistent'.

- Thats PHP yes but it works the same in C#

[reefcrazed]

Oh, so this is a part of connection pooling, when it is enabled. Correct ?

[Gilraak]

Oh, so this is a part of connection pooling, when it is enabled. Correct ?

Correct. It keeps the connection alive as long as MySQL can handle X amount of connections.

[reefcrazed]

Well there honestly needs to be more about that discussed online and in the documentation. I probably spent 4+ hours just reading about pooling, slowness and issues with the connector. It was discussed about pooling but the documentation on the connector 6.X was almost non existant.

[John Adams]

Yeah, that is the most frustrating part of all this for me is that the documentation is lacking, or lacking sense. People seem to write instructions like "Ok, to perform brain surgery, Step 1, remove the brain. Step 2, ... "etc... no idea whatsoever how to actually remove the brain itself. Smart people piss me off.

There are a few sites that have been extremely helpful for me to learn C# so far. codeprojects, daniweb, and stackoverflow. Even Microsoft's own site has been helpful with examples. I rarely invent my own code, 90% of the time I'm stealing someone elses and tweaking to work with my projects.

I don't think you should give up... if anything, it will get you more familiar with EQ2Emu, it's data, and how things flow. Plus, we might end up with an uber tool in the end We could always use more tools.

[reefcrazed]

Definitely no plans on giving up. I get frustrated, take two steps back, work on something else and then come back to it. There is no point on working on something when you are frustrated.

I am currently working on my EQ1 portal site and forum. Two projects I love are the EqEmulator and Eq2Emulator.

[John Adams]

There is no point on working on something when you are frustrated.

Funny you should say that. I was thinking the same thing myself these last 2 years;)

[reefcrazed]