Tapology Forums
Stats: Who is your most picked fighter?
Anonymous Mode
You are not logged in to Tapology. When browsing anonymously, profanities and images are automatically removed from the forum.
06.30.2020 | 12:39 PM ET
This surprised me
Most Picked Fighter: Donald "Cowboy" Cerrone
What most surprised me about this was that all the picks I made on Cerrone ended on 2015. I have not made a pick on him since.
Most Picked Fighter: Donald "Cowboy" Cerrone
- Picked 13 times
- Correct 12 times
What most surprised me about this was that all the picks I made on Cerrone ended on 2015. I have not made a pick on him since.
* Edited at 06.30.2020, 12:42 PM ET *
"For no particular reason beat up everyone"
Responses Page 3
07.05.2020 | 10:17 PM ET
lol holy **** Greg. Was that really warranted? I wasn't trying to throw tomatoes at you. However the system works, it still has to be predicated on some kind of Boolean condition(s) and the problem could be fixed by altering them.
I'm just gonna go kick rocks now.
Jesus...
I'm just gonna go kick rocks now.
Jesus...
This user is suspended from posting until 8 years, 11 months, 1 week, 5 days, 2 hours, and 31 minutes from now.
07.05.2020 | 10:32 PM ET
Go back and read your prior post. It was callous, given that you're talking to the person that wrote that "bad code" ... and ignorant, given that you don't know what you're talking about.
"I live, I die, I live again."
07.05.2020 | 10:51 PM ET
Well, yes,...but I'm not completely ********. I'm currently learning Python and algebraic computation is kind of what it is regardless of the application.
I wasn't saying you did a **** job or that I could do it better, or that I know more about than you do. That would be ridiculous. You said yourself you're not really happy with it--or inferred that, anyway.
I wasn't saying you did a **** job or that I could do it better, or that I know more about than you do. That would be ridiculous. You said yourself you're not really happy with it--or inferred that, anyway.
This user is suspended from posting until 8 years, 11 months, 1 week, 5 days, 2 hours, and 31 minutes from now.
07.06.2020 | 12:56 AM ET
@greg I think the way you guys have it set up is the way it should be. I wouldn't want it to be the fighters who's fight I've chosen the most. I like that it only counts when I pick that particular fighter.
"Super Necessary "
07.06.2020 | 1:59 AM ET
Literally every part of this that's confusing or annoying could be changed by adding an additional clause to the code.
Anyway, I don't think it's a big deal and I'm not going to be bothered whether it changes or it doesn't. Regardless I'm putting Greg's comment in my sig because whatever else it might be it is still very funny.
Anyway, I don't think it's a big deal and I'm not going to be bothered whether it changes or it doesn't. Regardless I'm putting Greg's comment in my sig because whatever else it might be it is still very funny.
* Edited at 07.06.2020, 2:04 AM ET *
This user is suspended from posting until 8 years, 11 months, 1 week, 5 days, 2 hours, and 31 minutes from now.
07.06.2020 | 9:57 AM ET
@fishrat for you and anyone else who might be mislead by what you are saying: it is NOT as simple as adding a "clause to the code." Since I'm a glutton for punishment I'll outline the basic contours of the problem.
Let's say you have a bout between Cerrone and Pettis. And you've picked Pettis. Now think about how this information is stored in our database.
User Table
- name: impfishrat
- id: 12345
Event Table
- id: 864
- Name: UFC London
- Date: 2019-02-01
Bout Table
- id: 98765
- event_id: 864 (this is the UFC London event)
- finishing method: TKO
- round: 2
Fighter Table
Entry 1...
- name: Cerrone
- id: 234
Entry 2...
- name: Pettis
- id: 789
Bout-to-Fighter Table
Entry 1...
- id: 100
- fighter_id: 234 (this is Cerrone)
- bout_id: 98765 (this is the Cerrone/Pettis bout)
- result: WIN
Entry 2...
- id: 101
- fighter_id: 789 (this is Pettis)
- bout_id: 98765 (this is the Cerrone/Pettis bout)
- result: LOSS
Pick Table
- id: 689237
- picked_fighter_id: 789
- picked_method: tko
- picked_round: 2
- bout_id: 98765
- user_id: 12345
- correct_fighter: false
- correct_method: false
- correct_round: false
If you want to know how many times you've picked a "Cerrone fight" you cannot just query the Pick Table (which has over 20 MILLION entries). Instead, you'd need to design a query that joins together every table outlined above. And since some users on this website have over 100,000 picks made, this query would entail combining:
- over 100,000 entries from the picks table
- over 200,000 entries from the bout-to-fighter table
- over 200,000 entries from the fighter table
- over 100,000 entries from the bout table
- probably over 10,000 or 20,000 entries from the event table
Then, with over 500,000 database objects stored IN MEMORY, in REAL TIME sorting through them to come up with the desired answer. So not only would this take far more than a "clause of code" to write all this logic, it would also fail to work. Once this logic was written, your browser would just hang waiting for an answer as the Tapology servers churned away doing the calculations. If too many people requested this page in close succession, or if people clicked refresh-refresh-refresh out of frustration, the Tapology servers would begin to melt down.
So unless you are an engineer that understands how to program scalable, efficient systems, you're not going to get anywhere!
"I live, I die, I live again."
-
- Hippie
07.06.2020 | 10:24 AM ET
^ Yikes!
07.06.2020 | 12:18 PM ET
Definitely something going on here, on the stats page it says 13-12 but in reality
16 Predictions · 14 - 2
Weird
16 Predictions · 14 - 2
Weird
- UFC 187 · 2015.05.23
- Donald Cerrone · Submission · Round 2
- UFC Fight Night 59 · 2015.01.18
- Donald Cerrone · Decision
- UFC 182 · 2015.01.03
- Donald Cerrone · Decision
- UFC 178 · 2014.09.27
- Donald Cerrone · Submission · Round 2
- UFC Fight Night 45 · 2014.07.16
- Donald Cerrone · KO/TKO · Round 1
- UFC on FOX 11 · 2014.04.19
- Donald Cerrone · KO/TKO · Round 1
- UFC on FOX 10 · 2014.01.25
- Donald Cerrone · Decision
- UFC 167 · 2013.11.16
- EvanDunham · Decision
- UFC Fight Night 27 · 2013.08.28
- DonaldCerrone · Decision
- UFC 160 · 2013.05.25
- Donald Cerrone · Decision
- UFC on FOX 6 · 2013.01.26
- Anthony Pettis · Submission · Round 2
- UFC 150 · 2012.08.11
- Donald Cerrone · Submission · Round 2
- UFC on FUEL TV 3 · 2012.05.15
- Donald Cerrone · Submission · Round 2
- UFC 141 · 2011.12.30
- Nate Diaz · Decision
- UFC 137 · 2011.10.29
- Donald Cerrone · Submission · Round 2
- UFC on Versus 5 · 2011.08.14
- Donald Cerrone · Decision
"For no particular reason beat up everyone"
07.06.2020 | 12:34 PM ET
oops
* Edited at 07.06.2020, 12:36 PM ET *
"For no particular reason beat up everyone"
07.06.2020 | 4:03 PM ET
@Greg ok, now we're getting somewhere, and I appreciate the response. Seems like a simple fix to me, you simply need one of these:
LOL. Anyway, I get what you're saying. Basically if you ran a script based on what I was talking about, Tapology would basically kind of 'DDOS' itself when queried this way. Isn't Tap built on Rails? I don't think that's a good platform for something as complicated as this site but I'm not throwing **** at you for that choice because when this site was created it would have literally been the best of all available options. But yeah....I looked into the Ruby language when you told me a while back that's the platform Tap uses and it kind of sucks in 2020 compared to what's out there IMO. It's horrifically slow compared to something like Python or C++ , Gems are weird, domain classes are obese and yick, doesn't seem conducive to Machine learning etc et al which is probably the way forward in avoiding weird issues like the one we're talking about.
Are you doing everything in Ruby or are you running scripts in Python or whatever via a module?
This user is suspended from posting until 8 years, 11 months, 1 week, 5 days, 2 hours, and 31 minutes from now.
07.06.2020 | 6:27 PM ET
Have you tried turning it off and on again?...?
"“I took no damage,” Hill said. “Most of the fall was me falling down"
This user is suspended from posting until 8 years, 11 months, 1 week, 5 days, 2 hours, and 31 minutes from now.
07.06.2020 | 7:34 PM ET
Vaso Bakocevic
* Edited at 07.06.2020, 7:44 PM ET *
"I am the greatest blonde man in the world. I am Tru Viking." - Alexander Gustaffsson / "The world must bow to my glory. I am a God amongst mortals. They must pay me tribute in wine and concubine for my deeds." - Jon Jones "
07.06.2020 | 10:30 PM ET
@fishrat I'm happy to help you understand some of this stuff. But why must you act like you know what you're talking about, when it's clear you don't? Ruby on Rails is an excellent foundation for a complex website. GitHub, Shopify, Basecamp, Twitch, AirBnB, Hulu, Groupon... these all are built on Rails.
Tapology does not use any Python, as there is absolutely no need for it. The so-called "DDOS" example are talking about has nothing to do with Ruby vs Python vs any other language. Rather, it's meant as an illustration of why what you think is an "easy" fix of "one clause" is not easy at all. It wouldn't matter what programming language you used.
"I live, I die, I live again."
07.07.2020 | 12:43 AM ET
I didn't say it had anything to do with the specific language of this site. I made a comment to the effect that if the code did work according to the way I said it should (which was wrong) then the net result would be a server overload due to a smash**** of queries that would work something like a DDOS. I was actually agreeing with you. I simply asked if you were using any Python via a module out of interest because that's what I'm learning currently.
And I still think Rails is obsolete and Ruby is a meh language.
Anyway I'm not going to continue responding to these ego-maniacal responses. I wasn't having a pop at you, and I always stand to be corrected, so I've no idea why you've gone on the defensive. My point was relation to the code and I made it in error without considering the systems-related implications of altering it. Not sure why you felt the need to tell me I know absolutely nothing about anything at all. Do you require--what--Perpetual deference?
And so although it's very gracious of you to offer tutelage gratas M'Lord, I fear as a simple man of three teeth, who smells of Poo and who yesterday attempted to bring down an Aeroplane with a spear, intending to cook and eat it, I am surely an unworthy beneficiary of your particular genius. It would be an exercise in futility; like attempting to teach time to a duck. And regardless I would not impose my wearisome imbecility on the World's preeminent programmer and admin who is surely on the verge of decrypting the bitrate of existence.In Ruby on Rails, no less. If I might be so bold as to make a meager request of your greatness, perhaps it might be possible to denote a fractal of your energy into creating a mobile app via a slight tipple from the font of the greatest Object-Oriented program in the universe?
And I still think Rails is obsolete and Ruby is a meh language.
Anyway I'm not going to continue responding to these ego-maniacal responses. I wasn't having a pop at you, and I always stand to be corrected, so I've no idea why you've gone on the defensive. My point was relation to the code and I made it in error without considering the systems-related implications of altering it. Not sure why you felt the need to tell me I know absolutely nothing about anything at all. Do you require--what--Perpetual deference?
And so although it's very gracious of you to offer tutelage gratas M'Lord, I fear as a simple man of three teeth, who smells of Poo and who yesterday attempted to bring down an Aeroplane with a spear, intending to cook and eat it, I am surely an unworthy beneficiary of your particular genius. It would be an exercise in futility; like attempting to teach time to a duck. And regardless I would not impose my wearisome imbecility on the World's preeminent programmer and admin who is surely on the verge of decrypting the bitrate of existence.In Ruby on Rails, no less. If I might be so bold as to make a meager request of your greatness, perhaps it might be possible to denote a fractal of your energy into creating a mobile app via a slight tipple from the font of the greatest Object-Oriented program in the universe?
* Edited at 07.07.2020, 12:58 AM ET *
This user is suspended from posting until 8 years, 11 months, 1 week, 5 days, 2 hours, and 31 minutes from now.