Register for your free account! | Forgot your password?

You last visited: Today at 01:18

  • Please register to post and access all features, it's quick, easy and FREE!

 

[Release] Fastest MySql System [C#]

Reply
 
Old   #16
 
elite*gold: 0
Join Date: Apr 2006
Posts: 223
Received Thanks: 91
if im not mistaken this is exactly how impulse did his in his source.



stealarcher is offline  
Old   #17
 
elite*gold: 0
Join Date: Jan 2011
Posts: 470
Received Thanks: 96
Quote:
Originally Posted by stealarcher View Post
if im not mistaken this is exactly how impulse did his in his source.
You are 100%, completely mistaking ><"
This isn't even remotely like his...
His is 600+ lines more than my system...


Spirited42 is offline  
Old   #18
 
elite*gold: 0
Join Date: Oct 2009
Posts: 755
Received Thanks: 531
Quote:
Originally Posted by Spirited View Post
You are 100%, completely mistaking ><"
This isn't even remotely like his...
His is 600+ lines more than my system...
Now depends, I wrote my wrapper because I hate MySQL syntax errors and how often they appear when you have to write your queries. Using functions to add parameters and so, it's much safer.

Though, the problem isn't really about how you manage your queries when you are dealing with MySQL. The problem is you have to restart your server once a few hours if you are using the .NET wrapper they give you. There is a bug in it.
One connection only can't handle all data and might close because of overloading, and, using the pool, after a few hours, your connections will be unusable. I managed to 'fix' a bit the wrapper(they give the source) and it only gives one errors once a few hours when you want to read data. My server is staying up for 1 day without restart, with at least 25 players every moment(for now only ) up to 90(max yet) and there is no problem with MySQL.

I suggest you use MySQL pooling, and try to fix the problem yourself, to prove you are worthy of having a server. I will not release the dll though.
-impulse- is offline  
Old   #19
 
elite*gold: 20
Join Date: Mar 2006
Posts: 6,227
Received Thanks: 2,476
Or just switch to MsSQL where the problem doesnt exist in the first place.


Korvacs is offline  
Old   #20
 
elite*gold: 0
Join Date: Oct 2009
Posts: 755
Received Thanks: 531
Quote:
Originally Posted by Korvacs View Post
Or just switch to MsSQL where the problem doesnt exist in the first place.
But then it would be harder to link php with the database. With MySQL there is everything already set up and it's just easier.
-impulse- is offline  
Old   #21
 
elite*gold: 20
Join Date: Mar 2006
Posts: 6,227
Received Thanks: 2,476
Quote:
Originally Posted by -impulse- View Post
But then it would be harder to link php with the database. With MySQL there is everything already set up and it's just easier.
Pretty backwards thinking, your priority should always always be the server, choosing a database just because the web side of things is more convenient is plain wrong...
Korvacs is offline  
Old   #22
 
elite*gold: 0
Join Date: Jan 2011
Posts: 470
Received Thanks: 96
Quote:
Originally Posted by Korvacs View Post
Pretty backwards thinking, your priority should always always be the server, choosing a database just because the web side of things is more convenient is plain wrong...
Actually... this handler was a MsSql handler...
It can easily be converted back.
Spirited42 is offline  
Old   #23
 
elite*gold: 0
Join Date: Apr 2011
Posts: 73
Received Thanks: 12
Quote:
Originally Posted by -impulse- View Post
But then it would be harder to link php with the database. With MySQL there is everything already set up and it's just easier.
That's why ASP.NET exist.
Secured is offline  
Old   #24
 
elite*gold: 0
Join Date: Nov 2010
Posts: 237
Received Thanks: 99
tho asp.net hosts are more expensive
|NeoX is offline  
Old   #25
 
elite*gold: 0
Join Date: Apr 2011
Posts: 73
Received Thanks: 12
Quote:
Originally Posted by |NeoX View Post
tho asp.net hosts are more expensive
You don't need an asp.net host for hosting local, since it's for interacting with the server
Secured is offline  
Old   #26
 
elite*gold: 0
Join Date: Sep 2008
Posts: 1,683
Received Thanks: 505
Funny how anyone believes this is new or even an imporvement on what most sources use right now. It's the same thing.
Next time you choose to 'compare' your fantastic work to existing work, run some tests and post the results here.
Calling yourself the best makes you look like an idiot anyway. Unless you can prove it ofc.
Basser is offline  
Thanks
1 User
Old   #27
 
elite*gold: 0
Join Date: Jan 2011
Posts: 470
Received Thanks: 96
Quote:
Originally Posted by Basser View Post
Funny how anyone believes this is new or even an imporvement on what most sources use right now. It's the same thing.
Next time you choose to 'compare' your fantastic work to existing work, run some tests and post the results here.
Calling yourself the best makes you look like an idiot anyway. Unless you can prove it ofc.
This system skips a lot of steps and doesn't store any data (thus using less RAM). It rids of 5 dictionaries in Impulse's system and uses 600 less lines. Learn what efficiency is before you post another comment on one of my threads.

PS: Yes. I know it's not the best. That's why I put it there. Challenge me if you think it's not with actual facts, not trolling.
Spirited42 is offline  
Old   #28
 
elite*gold: 0
Join Date: Jun 2009
Posts: 787
Received Thanks: 312
From a good programmar -> more lines (depending on the situation) = more efficient.

It's backwards to what you guys think it is.

Searching for a value in a sorted list - which is more efficient?

Code:
for (int i : list)
{
     if (i == val) return true;
}
return false;
or

Code:
int mid, min, max;
do {
  if (min >= max) return false;

  mid = (min + max) / 2;

  if (list[mid] < val) max = mid - 1;
  else if (list[mid] > val) min = mid + 1;
} while (list[mid] != val);
return true;
is more efficient at finding a value in a large set of sorted numbers?
_tao4229_ is offline  
Old   #29
 
elite*gold: 0
Join Date: Jan 2011
Posts: 470
Received Thanks: 96
Quote:
Originally Posted by _tao4229_ View Post
From a good programmar -> more lines (depending on the situation) = more efficient.

It's backwards to what you guys think it is.

Searching for a value in a sorted list - which is more efficient?

Code:
for (int i : list)
{
     if (i == val) return true;
}
return false;
or

Code:
int mid, min, max;
do {
  if (min >= max) return false;

  mid = (min + max) / 2;

  if (list[mid] < val) max = mid - 1;
  else if (list[mid] > val) min = mid + 1;
} while (list[mid] != val);
return true;
is more efficient at finding a value in a large set of sorted numbers?
That isn't the case though in this instance. Making 5 dictionaries for values to be send as objects is useless. All it is is a string builder. If you know how to build the string yourself, then the code isn't even needed.
Spirited42 is offline  
Old   #30
 
elite*gold: 20
Join Date: Jul 2006
Posts: 1,917
Received Thanks: 659
And PHP can be easily linked to mssql.


KraHen is offline  
Reply



« Previous Thread | Next Thread »

Similar Threads
Mysql Login System erstellen
Hallo zusammen =) ich mal wieder xD da mein anderes problem mit dem Kontaktformular noch in Arbeit ist, komme ich schon einmal zu meinem...
9 Replies - Web Development
Vote System zeigt MySQL Error
Hey, für unseren 2.4.3 Armemu Server wollten wir ein VOte System einbauen.. Klappte alles wunderbar aber es kommt wenn man auf "Vote now" klickt ein...
1 Replies - WoW Private Server
[Release] MySQL Insert system
Ello! First of all, this is NOT sourcedependent, which means you can use this on any source without modifying the code. This is an replacement...
18 Replies - CO2 PServer Guides & Releases
[Help CoEmuV2 (PHP/MYSQL required)] Donation system
I want an system if someone donated it updates an other column so: Confirmation Code : put something here // Mysql table: Dragonballs.Dcode...
2 Replies - CO2 PServer - Discussions / Questions



All times are GMT +1. The time now is 01:18.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Abuse
Copyright ©2017 elitepvpers All Rights Reserved.