|
You last visited: Today at 02:04
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.
04/14/2011, 10:35
|
#31
|
elite*gold: 0
Join Date: Nov 2010
Posts: 237
Received Thanks: 99
|
Quote:
Originally Posted by Spirited
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.
|
|
|
04/14/2011, 10:52
|
#32
|
elite*gold: 0
Join Date: Jan 2011
Posts: 470
Received Thanks: 97
|
Quote:
Originally Posted by |NeoX
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.
|
|
|
04/14/2011, 11:04
|
#33
|
elite*gold: 0
Join Date: Jul 2006
Posts: 2,216
Received Thanks: 793
|
Quote:
Originally Posted by Spirited
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?
|
|
|
04/14/2011, 11:37
|
#34
|
elite*gold: 0
Join Date: Nov 2010
Posts: 237
Received Thanks: 99
|
Quote:
Originally Posted by Spirited
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...
|
|
|
04/14/2011, 12:15
|
#35
|
elite*gold: 0
Join Date: Jan 2011
Posts: 470
Received Thanks: 97
|
Quote:
Originally Posted by KraHen
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.
|
|
|
04/14/2011, 12:24
|
#36
|
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.
|
|
|
04/14/2011, 12:27
|
#37
|
elite*gold: 20
Join Date: Mar 2006
Posts: 6,125
Received Thanks: 2,518
|
Quote:
Originally Posted by Spirited
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.
|
|
|
04/14/2011, 12:30
|
#38
|
elite*gold: 0
Join Date: Apr 2011
Posts: 73
Received Thanks: 12
|
Quote:
Originally Posted by Spirited
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.
|
|
|
04/14/2011, 12:30
|
#39
|
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.
|
|
|
04/14/2011, 12:39
|
#40
|
elite*gold: 0
Join Date: Apr 2011
Posts: 73
Received Thanks: 12
|
Quote:
Originally Posted by Spirited
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.
|
|
|
04/14/2011, 18:27
|
#41
|
elite*gold: 0
Join Date: Oct 2009
Posts: 768
Received Thanks: 550
|
Quote:
Originally Posted by Korvacs
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.
|
|
|
04/14/2011, 18:50
|
#42
|
elite*gold: 0
Join Date: Nov 2010
Posts: 237
Received Thanks: 99
|
Quote:
Originally Posted by Spirited
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.
|
|
|
04/14/2011, 20:39
|
#43
|
elite*gold: 0
Join Date: Apr 2011
Posts: 73
Received Thanks: 12
|
Quote:
Originally Posted by |NeoX
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.
|
|
|
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]
}
|
|
|
04/15/2011, 14:30
|
#45
|
elite*gold: 0
Join Date: Jul 2006
Posts: 2,216
Received Thanks: 793
|
nooo way a recursive version is so much faster than that
|
|
|
|
|
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.
|
|