|
||
|
Jockstocks Today Currently pertinent Game/Sports related topics |
Thread Tools | Search this Thread | Display Modes |
#1
|
|||
|
|||
Extremely slow Market2
I've been experiencing an extremely slow Market2 over the last several days. Approximately 30 seconds per buy.
Anyone else having these issues? Prone
__________________
14x Monthly Competition Winner: 2023 Sep, 2021 Aug/Jul/May, 2017 Feb/Jan, 2016 Feb/Jan, 2015 Dec/Nov/Jan, 2014 Mar/Jan, 2013 Jul 7x Quarterly Competition Winner: 2021Q3, 2017Q1, 2016Q1, 2015Q3/Q1, 2014Q1, 2013Q3 5x Yearly Competition Winner: 2017, 2016, 2015, 2014, 2011 8x PGA Competition Winner: 2020 (1st half), 2017 (1st half) 2016 (1st & 2nd half), 2015 (1st & 2nd half), 2011 (1st & 2nd half) 1x NASCAR Competition Winner: 2021 (2nd half) *** All-time Yearly Portfolio Value Record: $58.5 billion (2015); $57.8B (2017); $57.7B (2016) *** |
#2
|
||||
|
||||
Story time.
With out downtime on Sunday, we moved one server from the KC datacent up to the Amazon Cloud (in Ohio). Yay for reliability. However, what's happened is it's exposed the fact that MANY of our database queries are incredibly inefficient. When the servers were sitting within feet of each other, and we were utilizing the datacenter's internal DNS, we didn't notice how inefficient the queries were. They were still only taking nanoseconds to respond. However, when they are moving from KC to Ohio, they are taking more like milliseconds, and they add up very, very quickly. So, in short, I'm trying to get everything updated. I'll take a look at Market2 after I finish fixing a few of the other scripts (leaderboard generation, dividend calculation, etc), I'll take a peak at Market2. Thanks for bringing it to my attention; I hadn't noticed! Nick |
#3
|
||||
|
||||
Every buy, all the time is taking 30 seconds? I just purchased Duffman in my Baseball Only port and it took about two seconds.
|
#4
|
|||
|
|||
Yes, all the time for me. Same for yearly and TV.
For context, I used to be able to buy up entire page 1 buys on Market2 in about 3 seconds. Now it is taking me a good 5 minutes. I actually just timed it and I was able to buy 14 players using Market2 and it took 3 minutes, 44 seconds (so actually a little under 20 seconds per max buy, but it FEELS like 30+ seconds while you are sitting and waiting.
__________________
14x Monthly Competition Winner: 2023 Sep, 2021 Aug/Jul/May, 2017 Feb/Jan, 2016 Feb/Jan, 2015 Dec/Nov/Jan, 2014 Mar/Jan, 2013 Jul 7x Quarterly Competition Winner: 2021Q3, 2017Q1, 2016Q1, 2015Q3/Q1, 2014Q1, 2013Q3 5x Yearly Competition Winner: 2017, 2016, 2015, 2014, 2011 8x PGA Competition Winner: 2020 (1st half), 2017 (1st half) 2016 (1st & 2nd half), 2015 (1st & 2nd half), 2011 (1st & 2nd half) 1x NASCAR Competition Winner: 2021 (2nd half) *** All-time Yearly Portfolio Value Record: $58.5 billion (2015); $57.8B (2017); $57.7B (2016) *** |
#5
|
||||
|
||||
Ok, thanks for the additional information. Buying 20 took 1.9 minutes... yikes! I've updated almost all of the LB scripts, so I'll try to look at it tomorrow. Thanks again!
Nick |
#6
|
|||
|
|||
all my buys take close to a minute. sells are fine.
|
#7
|
||||
|
||||
Any specific portfolio or all of them?
Nick |
#8
|
|||
|
|||
I only play total value.
And this happened both times i replied today i first had to log in per this vbulletin message i have never seen before: You are not logged in or you do not have permission to access this page. This could be due to one of several reasons: You are not logged in. Fill in the form at the bottom of this page and try again. You may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system? If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation. |
#9
|
||||
|
||||
Quote:
|
#10
|
|||
|
|||
Very strange message for me too when I tried to buy off of the Market2 page:
"You have purchased 10000 shares of 0 at the price of $0.00, for a total of $50.00." I have no idea what this did to my holdings or cash, but hey, maybe I wanted 10000 shares of 0.
__________________
14x Monthly Competition Winner: 2023 Sep, 2021 Aug/Jul/May, 2017 Feb/Jan, 2016 Feb/Jan, 2015 Dec/Nov/Jan, 2014 Mar/Jan, 2013 Jul 7x Quarterly Competition Winner: 2021Q3, 2017Q1, 2016Q1, 2015Q3/Q1, 2014Q1, 2013Q3 5x Yearly Competition Winner: 2017, 2016, 2015, 2014, 2011 8x PGA Competition Winner: 2020 (1st half), 2017 (1st half) 2016 (1st & 2nd half), 2015 (1st & 2nd half), 2011 (1st & 2nd half) 1x NASCAR Competition Winner: 2021 (2nd half) *** All-time Yearly Portfolio Value Record: $58.5 billion (2015); $57.8B (2017); $57.7B (2016) *** |
#11
|
||||
|
||||
Quote:
Nick EDIT: Nevermind. I see them now! |
#12
|
||||
|
||||
The issue has been resolved. Prone, I sent you a message.
Nick |
#13
|
||||
|
||||
__________________
Having a dog named shark at the beach was a bad idea Why is there a highway to hell but only a stairway to heaven It's wierd being the same age as old people My mom didn't raise no dummy, if she did it would be my sister I told my wife to embrace her faults......she hugged me I took a DNA test- God is my father When I ask if you want me to be honest, please say no |
#14
|
||||
|
||||
The problem only appears to be with TV ports....buys this morning are taking 65 seconds.
__________________
Having a dog named shark at the beach was a bad idea Why is there a highway to hell but only a stairway to heaven It's wierd being the same age as old people My mom didn't raise no dummy, if she did it would be my sister I told my wife to embrace her faults......she hugged me I took a DNA test- God is my father When I ask if you want me to be honest, please say no |
#15
|
|||
|
|||
It's not as bad for the other ports, but still noticeable depending on port size. For instance, my Yearly port takes about 3 seconds per max buy whereas my other ports are almost instant.
__________________
14x Monthly Competition Winner: 2023 Sep, 2021 Aug/Jul/May, 2017 Feb/Jan, 2016 Feb/Jan, 2015 Dec/Nov/Jan, 2014 Mar/Jan, 2013 Jul 7x Quarterly Competition Winner: 2021Q3, 2017Q1, 2016Q1, 2015Q3/Q1, 2014Q1, 2013Q3 5x Yearly Competition Winner: 2017, 2016, 2015, 2014, 2011 8x PGA Competition Winner: 2020 (1st half), 2017 (1st half) 2016 (1st & 2nd half), 2015 (1st & 2nd half), 2011 (1st & 2nd half) 1x NASCAR Competition Winner: 2021 (2nd half) *** All-time Yearly Portfolio Value Record: $58.5 billion (2015); $57.8B (2017); $57.7B (2016) *** |