Home
Portfolio
Market
Market2
Leaders
Pick'em
Messenger
Oasis

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
All Pro
 
Join Date: Jun 2008
Location: Fairborn, OH
Posts: 623
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
__________________

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  
Unread 29 Aug 2018, 10:54 PM
StockTrader StockTrader is offline
Administrator
 
Join Date: Mar 2007
Location: Olathe, KS
Posts: 3,018
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
  #3  
Unread 29 Aug 2018, 11:28 PM
StockTrader StockTrader is offline
Administrator
 
Join Date: Mar 2007
Location: Olathe, KS
Posts: 3,018
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.
  #4  
Unread 29 Aug 2018, 11:37 PM
ProneEisenrott ProneEisenrott is offline
All Pro
 
Join Date: Jun 2008
Location: Fairborn, OH
Posts: 623
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.
__________________

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  
Unread 30 Aug 2018, 01:06 AM
StockTrader StockTrader is offline
Administrator
 
Join Date: Mar 2007
Location: Olathe, KS
Posts: 3,018
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
  #6  
Unread 30 Aug 2018, 02:31 PM
bballjer44 bballjer44 is offline
Head Coach
 
Join Date: Mar 2007
Location: West Chicago, Illinois
Posts: 2,497
Default

all my buys take close to a minute. sells are fine.
  #7  
Unread 30 Aug 2018, 08:56 PM
StockTrader StockTrader is offline
Administrator
 
Join Date: Mar 2007
Location: Olathe, KS
Posts: 3,018
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
  #8  
Unread 30 Aug 2018, 09:06 PM
bballjer44 bballjer44 is offline
Head Coach
 
Join Date: Mar 2007
Location: West Chicago, Illinois
Posts: 2,497
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.
  #9  
Unread 30 Aug 2018, 09:15 PM
StockTrader StockTrader is offline
Administrator
 
Join Date: Mar 2007
Location: Olathe, KS
Posts: 3,018
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.
  #10  
Unread 30 Aug 2018, 10:16 PM
ProneEisenrott ProneEisenrott is offline
All Pro
 
Join Date: Jun 2008
Location: Fairborn, OH
Posts: 623
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.
__________________

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  
Unread 30 Aug 2018, 10:27 PM
StockTrader StockTrader is offline
Administrator
 
Join Date: Mar 2007
Location: Olathe, KS
Posts: 3,018
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!
  #12  
Unread 30 Aug 2018, 11:02 PM
StockTrader StockTrader is offline
Administrator
 
Join Date: Mar 2007
Location: Olathe, KS
Posts: 3,018
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
  #13  
Unread 31 Aug 2018, 05:43 PM
rich76 rich76 is offline
Moderator
 
Join Date: Mar 2007
Location: Southport, N.C.
Posts: 20,352
Default

__________________
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  
Unread 02 Sep 2018, 06:55 AM
rich76 rich76 is offline
Moderator
 
Join Date: Mar 2007
Location: Southport, N.C.
Posts: 20,352
Default

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  
Unread 02 Sep 2018, 08:07 AM
ProneEisenrott ProneEisenrott is offline
All Pro
 
Join Date: Jun 2008
Location: Fairborn, OH
Posts: 623
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.
__________________

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) ***



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 11:28 AM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
© 2007 - 2011 Jockstocks
Jockstocks Forums Database Error
Database Error Database error
The Jockstocks Forums database has encountered a problem.

Please try the following:
  • Load the page again by clicking the Refresh button in your web browser.
  • Open the forums.jockstocks.com home page, then try to open another page.
  • Click the Back button to try another link.
The forums.jockstocks.com forum technical staff have been notified of the error, though you may contact them if the problem persists.
 
We apologise for any inconvenience.