Register for your free account! | Forgot your password?

You last visited: Today at 02:04

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

Advertisement



[Release] Fastest MySql System [C#]

Discussion on [Release] Fastest MySql System [C#] within the CO2 PServer Guides & Releases forum part of the CO2 Private Server category.

Reply
 
Old 04/14/2011, 10:35   #31
 
|NeoX's Avatar
 
elite*gold: 0
Join Date: Nov 2010
Posts: 237
Received Thanks: 99
Quote:
Originally Posted by Spirited View Post
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.
Nope, saint is still right in your case.
|NeoX is offline  
Old 04/14/2011, 10:52   #32
 
elite*gold: 0
Join Date: Jan 2011
Posts: 470
Received Thanks: 97
Quote:
Originally Posted by |NeoX View Post
Nope, saint is still right in your case.
What are you talking about? Of course he's not. Why the hell would you add dictionaries to build a string when you can just tell if what the hell the string is and send it? That makes no sense.
Spirited42 is offline  
Old 04/14/2011, 11:04   #33


 
KraHen's Avatar
 
elite*gold: 0
Join Date: Jul 2006
Posts: 2,216
Received Thanks: 793
Quote:
Originally Posted by Spirited View Post
What are you talking about? Of course he's not. Why the hell would you add dictionaries to build a string when you can just tell if what the hell the string is and send it? That makes no sense.
Efficiency vs length of code. It was a generic sample of the main idea, is it really that hard to understand?
KraHen is offline  
Thanks
2 Users
Old 04/14/2011, 11:37   #34
 
|NeoX's Avatar
 
elite*gold: 0
Join Date: Nov 2010
Posts: 237
Received Thanks: 99
Quote:
Originally Posted by Spirited View Post
What are you talking about? Of course he's not. Why the hell would you add dictionaries to build a string when you can just tell if what the hell the string is and send it? That makes no sense.
Why would you even build a string

Korvacs told you about stored procedures...
|NeoX is offline  
Old 04/14/2011, 12:15   #35
 
elite*gold: 0
Join Date: Jan 2011
Posts: 470
Received Thanks: 97
Quote:
Originally Posted by KraHen View Post
Efficiency vs length of code. It was a generic sample of the main idea, is it really that hard to understand?
1. I ******* understand it. Shut the hell up and start reading. I'm not talking about the **** Saint brought up. If you want to make 5 dictionaries to build a string then go for it. I'm going to keep writing them out by hand.

2. Stop trolling. This thread has lived up to its purpose. Sad how this forum has such a huge problem with people like you. This is my last post. I'm going private for now on, and forever. Say what you will, I don't give a ****- because I know you will and I know what you'll say. Say it all you want- but this forum is still going to be a hell hole. I'm going to live on with my life. There's no need for a forum like this.

This is how coders go cold.
Spirited42 is offline  
Old 04/14/2011, 12:24   #36


 
KraHen's Avatar
 
elite*gold: 0
Join Date: Jul 2006
Posts: 2,216
Received Thanks: 793
*** ******* dammit. That was NOT an example for YOUR case, it was an example in GENERAL PROGRAMMING. He was basically proving that length of code doesn`t always mean better performance. Stop acting like you`re the uberbrain here, it`s really ******* annoying.
KraHen is offline  
Old 04/14/2011, 12:27   #37


 
Korvacs's Avatar
 
elite*gold: 20
Join Date: Mar 2006
Posts: 6,125
Received Thanks: 2,518
Quote:
Originally Posted by Spirited View Post
No, it's not. Why the hell would you want to make 5 dictionaries to build a ******* string though if you can just ******* write it? THAT is what isn't making any sense to me. Explain yourself. If you can't then this thread has met its purpose.
No one in the thread ever stated that using 5 dictionaries to build a query was faster than the assignment used to create a string query. Your the one who has been pushing that idea.

Saint suggested that in some cases having more lines of code results in more efficient code, he did not state that using a single string is less efficient than 5 dictionaries.
Korvacs is offline  
Thanks
1 User
Old 04/14/2011, 12:30   #38
 
elite*gold: 0
Join Date: Apr 2011
Posts: 73
Received Thanks: 12
Quote:
Originally Posted by Spirited View Post
1. I ******* understand it. Shut the hell up and start reading. I'm not talking about the **** Saint brought up. If you want to make 5 dictionaries to build a string then go for it. I'm going to keep writing them out by hand.

2. Stop trolling. This thread has lived up to its purpose. Sad how this forum has such a huge problem with people like you. This is my last post. I'm going private for now on, and forever. Say what you will, I don't give a ****- because I know you will and I know what you'll say. Say it all you want- but this forum is still going to be a hell hole. I'm going to live on with my life. There's no need for a forum like this.

This is how coders go cold.
Longer code != Less efficient.
Secured is offline  
Old 04/14/2011, 12:30   #39


 
KraHen's Avatar
 
elite*gold: 0
Join Date: Jul 2006
Posts: 2,216
Received Thanks: 793
Please close this thread, I`m slowly getting to the point where I`ll get up that old beretta and shoot myself.

Congratulations, you`re the perfect example for a very severe case of arrogancy.
KraHen is offline  
Old 04/14/2011, 12:39   #40
 
elite*gold: 0
Join Date: Apr 2011
Posts: 73
Received Thanks: 12
Quote:
Originally Posted by Spirited View Post
Removed.

Why do you think?
Is it really THAT shocking to you that I removed it?
I lol'd. It's still on the internet.
Secured is offline  
Old 04/14/2011, 18:27   #41
 
elite*gold: 0
Join Date: Oct 2009
Posts: 768
Received Thanks: 550
Quote:
Originally Posted by Korvacs View Post
No one in the thread ever stated that using 5 dictionaries to build a query was faster than the assignment used to create a string query. Your the one who has been pushing that idea.

Saint suggested that in some cases having more lines of code results in more efficient code, he did not state that using a single string is less efficient than 5 dictionaries.
You probably seen the way I wrote my MySQLCommand class. Well, for the insert command I use 5 dictionaries ( can be used one only actually ) to store the info for the insert command. When Execute() is called, the data from the dictionaries will be gathered together in the string. Then it's cleared.

Though, using my wrapper will only cost you the time of calling the function and ending the call, which is a matter of nano seconds and shouldn't even count.

Haven't tried the stored procedures yet, will try them later.
-impulse- is offline  
Old 04/14/2011, 18:50   #42
 
|NeoX's Avatar
 
elite*gold: 0
Join Date: Nov 2010
Posts: 237
Received Thanks: 99
Quote:
Originally Posted by Spirited View Post
1. I ******* understand it. Shut the hell up and start reading. I'm not talking about the **** Saint brought up. If you want to make 5 dictionaries to build a string then go for it. I'm going to keep writing them out by hand.

2. Stop trolling. This thread has lived up to its purpose. Sad how this forum has such a huge problem with people like you. This is my last post. I'm going private for now on, and forever. Say what you will, I don't give a ****- because I know you will and I know what you'll say. Say it all you want- but this forum is still going to be a hell hole. I'm going to live on with my life. There's no need for a forum like this.

This is how coders go cold.
U said that like 20 times this year and about 200 times last year mate.
|NeoX is offline  
Thanks
2 Users
Old 04/14/2011, 20:39   #43
 
elite*gold: 0
Join Date: Apr 2011
Posts: 73
Received Thanks: 12
Quote:
Originally Posted by |NeoX View Post
U said that like 20 times this year and about 200 times last year mate.
He is back next week with a new name and the best source.
Secured is offline  
Old 04/14/2011, 22:11   #44
 
elite*gold: 0
Join Date: Jun 2009
Posts: 787
Received Thanks: 314
Never seen the wrapper, but dictionaries are still useful in efficiency.

Code:
dict[int,int] memo

int fib(n) {
  if (!memo.contains(n)) {
     int r = fib (n-1) + fib (n-2)
     memo.add(n, r)
     return r
  }
  else return memo[n]
}
_tao4229_ is offline  
Old 04/15/2011, 14:30   #45


 
KraHen's Avatar
 
elite*gold: 0
Join Date: Jul 2006
Posts: 2,216
Received Thanks: 793
nooo way a recursive version is so much faster than that
KraHen is offline  
Reply


Similar Threads Similar Threads
Mysql Login System erstellen
04/04/2011 - Web Development - 9 Replies
Hallo zusammen =) ich mal wieder xD da mein anderes problem mit dem Kontaktformular noch in Arbeit ist, komme ich schon einmal zu meinem nächsten Problem ich habe ,nach dem Tutorial von Hier Eine Datenbank erstellt und bin schon bei Punkt 2 und genau da tritt mein problem auf....
Vote System zeigt MySQL Error
01/07/2011 - WoW Private Server - 1 Replies
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 MySQL Erro: Unknown column 'votes' in 'field list' Folgende Dbs sind vorhanden: rewars shoplog topsites votelog
[Release] MySQL Insert system
07/18/2010 - CO2 PServer Guides & Releases - 18 Replies
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 for all of you who still uses normal MySQL queries. Use this code to clean up, make it easier and more orginazed. Here's how it looks: Example: (Original (LOTF for example))
[Help CoEmuV2 (PHP/MYSQL required)] Donation system
07/18/2009 - CO2 Private Server - 2 Replies
I want an system if someone donated it updates an other column so: Confirmation Code : put something here // Mysql table: Dragonballs.Dcode Confirmation Pass : put something here // Mysql table: Dragonballs.Dpass And then if you click claim it updates the table/column : Characters.Prize With the amount of : Dragonballs.Damount



All times are GMT +2. The time now is 02:04.


Powered by vBulletin®
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2024 elitepvpers All Rights Reserved.