Home
Portfolio
Market
Market2
Leaders
Pick'em
Pick 10
Messenger
Oasis
Vote

Go Back   Jockstocks Forums > Game Related > Jockstocks Today
FAQ Calendar Search Today's Posts Mark Forums Read

Jockstocks Today Currently pertinent Game/Sports related topics

Reply
Thread Tools Search this Thread Display Modes
  #1  
Unread 29 Aug 2018, 10:16 PM
ProneEisenrott ProneEisenrott is offline
Standout
 
Join Date: Jun 2008
Location: Fairborn, OH
Posts: 478
Default 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
__________________

7x PGA Competition Winner: 2017 (1st half) 2016 (1st & 2nd half), 2015 (1st & 2nd half), 2011 (1st & 2nd half)
10x Monthly Competition Winner: 2017 Feb/Jan, 2016 Feb/Jan, 2015 Dec/Nov/Jan, 2014 Mar/Jan, 2013 Jul
6x Quarterly Competition Winner: 2017Q1, 2016Q1, 2015Q3/Q1, 2014Q1, 2013Q3
5x Yearly Competition Winner: 2017, 2016, 2015, 2014, 2011
*** All-time Yearly Portfolio Value Record: $58.5 billion (2015); $57.8B (2017); $57.7B (2016) ***


Reply With Quote
  #2  
Unread 29 Aug 2018, 10:54 PM
StockTrader's Avatar
StockTrader StockTrader is offline
Administrator
 
Join Date: Mar 2007
Location: Olathe, KS
Posts: 2,980
Send a message via MSN to StockTrader Send a message via Yahoo to StockTrader
Default

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
Reply With Quote
  #3  
Unread 29 Aug 2018, 11:28 PM
StockTrader's Avatar
StockTrader StockTrader is offline
Administrator
 
Join Date: Mar 2007
Location: Olathe, KS
Posts: 2,980
Send a message via MSN to StockTrader Send a message via Yahoo to StockTrader
Default

Every buy, all the time is taking 30 seconds? I just purchased Duffman in my Baseball Only port and it took about two seconds.
Reply With Quote
  #4  
Unread 29 Aug 2018, 11:37 PM
ProneEisenrott ProneEisenrott is offline
Standout
 
Join Date: Jun 2008
Location: Fairborn, OH
Posts: 478
Default

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.
__________________

7x PGA Competition Winner: 2017 (1st half) 2016 (1st & 2nd half), 2015 (1st & 2nd half), 2011 (1st & 2nd half)
10x Monthly Competition Winner: 2017 Feb/Jan, 2016 Feb/Jan, 2015 Dec/Nov/Jan, 2014 Mar/Jan, 2013 Jul
6x Quarterly Competition Winner: 2017Q1, 2016Q1, 2015Q3/Q1, 2014Q1, 2013Q3
5x Yearly Competition Winner: 2017, 2016, 2015, 2014, 2011
*** All-time Yearly Portfolio Value Record: $58.5 billion (2015); $57.8B (2017); $57.7B (2016) ***



Last edited by ProneEisenrott; 29 Aug 2018 at 11:45 PM.
Reply With Quote
  #5  
Unread 30 Aug 2018, 01:06 AM
StockTrader's Avatar
StockTrader StockTrader is offline
Administrator
 
Join Date: Mar 2007
Location: Olathe, KS
Posts: 2,980
Send a message via MSN to StockTrader Send a message via Yahoo to StockTrader
Default

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
Reply With Quote
  #6  
Unread 30 Aug 2018, 02:31 PM
bballjer44 bballjer44 is online now
Head Coach
 
Join Date: Mar 2007
Location: Illinois
Posts: 2,259
Default

all my buys take close to a minute. sells are fine.
Reply With Quote
  #7  
Unread 30 Aug 2018, 08:56 PM
StockTrader's Avatar
StockTrader StockTrader is offline
Administrator
 
Join Date: Mar 2007
Location: Olathe, KS
Posts: 2,980
Send a message via MSN to StockTrader Send a message via Yahoo to StockTrader
Default

Quote:
Originally Posted by bballjer44 View Post
all my buys take close to a minute. sells are fine.
Any specific portfolio or all of them?

Nick
Reply With Quote
  #8  
Unread 30 Aug 2018, 09:06 PM
bballjer44 bballjer44 is online now
Head Coach
 
Join Date: Mar 2007
Location: Illinois
Posts: 2,259
Default

Quote:
Originally Posted by StockTrader View Post
Any specific portfolio or all of them?

Nick
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.
Reply With Quote
  #9  
Unread 30 Aug 2018, 09:15 PM
StockTrader's Avatar
StockTrader StockTrader is offline
Administrator
 
Join Date: Mar 2007
Location: Olathe, KS
Posts: 2,980
Send a message via MSN to StockTrader Send a message via Yahoo to StockTrader
Default

Quote:
Originally Posted by bballjer44 View Post
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.
Very, very odd. I'll see what I can see.
Reply With Quote
  #10  
Unread 30 Aug 2018, 10:16 PM
ProneEisenrott ProneEisenrott is offline
Standout
 
Join Date: Jun 2008
Location: Fairborn, OH
Posts: 478
Default

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.
__________________

7x PGA Competition Winner: 2017 (1st half) 2016 (1st & 2nd half), 2015 (1st & 2nd half), 2011 (1st & 2nd half)
10x Monthly Competition Winner: 2017 Feb/Jan, 2016 Feb/Jan, 2015 Dec/Nov/Jan, 2014 Mar/Jan, 2013 Jul
6x Quarterly Competition Winner: 2017Q1, 2016Q1, 2015Q3/Q1, 2014Q1, 2013Q3
5x Yearly Competition Winner: 2017, 2016, 2015, 2014, 2011
*** All-time Yearly Portfolio Value Record: $58.5 billion (2015); $57.8B (2017); $57.7B (2016) ***


Reply With Quote
  #11  
Unread 30 Aug 2018, 10:27 PM
StockTrader's Avatar
StockTrader StockTrader is offline
Administrator
 
Join Date: Mar 2007
Location: Olathe, KS
Posts: 2,980
Send a message via MSN to StockTrader Send a message via Yahoo to StockTrader
Default

Quote:
Originally Posted by ProneEisenrott View Post
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.
That was my fault. Who did you buy?

Nick

EDIT: Nevermind. I see them now!
Reply With Quote
  #12  
Unread 30 Aug 2018, 11:02 PM
StockTrader's Avatar
StockTrader StockTrader is offline
Administrator
 
Join Date: Mar 2007
Location: Olathe, KS
Posts: 2,980
Send a message via MSN to StockTrader Send a message via Yahoo to StockTrader
Default

The issue has been resolved. Prone, I sent you a message.

Nick
Reply With Quote
  #13  
Unread 31 Aug 2018, 05:43 PM
rich76's Avatar
rich76 rich76 is online now
Moderator
 
Join Date: Mar 2007
Location: Southport, N.C.
Posts: 16,687
Default

__________________
You may not believe in guns and you may not believe in God. ...but if someone breaks into your home I guarantee the 1st two things you'll do is call someone with a gun and pray they get there in time
A veteran is someone who, at one point in his life wrote a blank check made payable to 'The United States of America ' for an amount of 'up to and including my life.' That is Honor, and there are way too many people in this country who no longer understand it.'
IMHO we finally have a POTUS that will get us back on the right track. We survived the community organizer but I am not optimistic that he will just go away and enjoy his ill-gotten wealth.
God bless our Troops.
Reply With Quote
  #14  
Unread 02 Sep 2018, 06:55 AM
rich76's Avatar
rich76 rich76 is online now
Moderator
 
Join Date: Mar 2007
Location: Southport, N.C.
Posts: 16,687
Default

The problem only appears to be with TV ports....buys this morning are taking 65 seconds.
__________________
You may not believe in guns and you may not believe in God. ...but if someone breaks into your home I guarantee the 1st two things you'll do is call someone with a gun and pray they get there in time
A veteran is someone who, at one point in his life wrote a blank check made payable to 'The United States of America ' for an amount of 'up to and including my life.' That is Honor, and there are way too many people in this country who no longer understand it.'
IMHO we finally have a POTUS that will get us back on the right track. We survived the community organizer but I am not optimistic that he will just go away and enjoy his ill-gotten wealth.
God bless our Troops.
Reply With Quote
  #15  
Unread 02 Sep 2018, 08:07 AM
ProneEisenrott ProneEisenrott is offline
Standout
 
Join Date: Jun 2008
Location: Fairborn, OH
Posts: 478
Default

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.
__________________

7x PGA Competition Winner: 2017 (1st half) 2016 (1st & 2nd half), 2015 (1st & 2nd half), 2011 (1st & 2nd half)
10x Monthly Competition Winner: 2017 Feb/Jan, 2016 Feb/Jan, 2015 Dec/Nov/Jan, 2014 Mar/Jan, 2013 Jul
6x Quarterly Competition Winner: 2017Q1, 2016Q1, 2015Q3/Q1, 2014Q1, 2013Q3
5x Yearly Competition Winner: 2017, 2016, 2015, 2014, 2011
*** All-time Yearly Portfolio Value Record: $58.5 billion (2015); $57.8B (2017); $57.7B (2016) ***


Reply With Quote
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 10:08 PM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2018, vBulletin Solutions, Inc.
© 2007 - 2011 Jockstocks