 |
View Old Forum Thread
Old Forum Index » Sim Forums » Latest News » More Changes to News
tysonlowery
Now you will see all news items for the last 365 Sim days whenever you click on a News item. There is a link to show older news at the bottom of each one.
Name Changes will show all name changes.
Most of the Show All news links should still be fairly fast. The exception is when you see all news categories for alltime. I've been able to optimize things to work fairly quickly.
For those of you that are programmers, the key to all this was turning on an option in MySQL that allows inserting of new rows the same time reads of that table are going on - its a flag called concurrent_inserts. It works if you don't have any overhead on the table. Because of this, I can allow more rows to be returned without risking any locks.
More Changes to News
July 23, 2006 at 05:56PM View BBCode
Ok, I've reversed some of the earlier changes to news, based on some new findings.Now you will see all news items for the last 365 Sim days whenever you click on a News item. There is a link to show older news at the bottom of each one.
Name Changes will show all name changes.
Most of the Show All news links should still be fairly fast. The exception is when you see all news categories for alltime. I've been able to optimize things to work fairly quickly.
For those of you that are programmers, the key to all this was turning on an option in MySQL that allows inserting of new rows the same time reads of that table are going on - its a flag called concurrent_inserts. It works if you don't have any overhead on the table. Because of this, I can allow more rows to be returned without risking any locks.
tworoosters
July 26, 2006 at 10:12PM View BBCode
News is showing "olds" - Bob Horner league date is August 30th yet news shows only transactions to August 12.
redcped
Makes it hard to know if trades have occurred, etc.
July 26, 2006 at 11:51PM View BBCode
I notice the same problem. Waiver moves I'd seen this morning are gone now.Makes it hard to know if trades have occurred, etc.
alexlevy
July 27, 2006 at 03:05AM View BBCode
Same thing in the Ken Griffey League. THe news reverted to six days back.
CaseyStengel
Check: [url=http://www.simdynasty.com/player.jsp?id=2628692] Wayne Terwilliger[/url] for a player card example.
July 27, 2006 at 04:08AM View BBCode
Orlando Cepeda League stopped reporting the news after 3/16/1988. Player Cards, however, show the news that involved the player.Check: [url=http://www.simdynasty.com/player.jsp?id=2628692] Wayne Terwilliger[/url] for a player card example.
tysonlowery
July 27, 2006 at 01:33PM View BBCode
http://www.simdynasty.com/oldforum-viewthread.jsp?tid=108836
jetpac
July 27, 2006 at 03:17PM View BBCode
I noticed that when a player's name was changed back to his original name (example: [url=http://www.simdynasty.com/player.jsp?player=nobody&mode=stats&id=1413089]Pete Griffin[/url]) it shows the previous transactions. Was that part of this group of upgrades, or did that happen earlier, and I just missed it?
BleedRed
I don't believe that is new. News always reported all name changes.
July 27, 2006 at 03:19PM View BBCode
Originally posted by jetpac
I noticed that when a player's name was changed back to his original name (example: [url=http://www.simdynasty.com/player.jsp?player=nobody&mode=stats&id=1413089]Pete Griffin[/url]) it shows the previous transactions. Was that part of this group of upgrades, or did that happen earlier, and I just missed it?
I don't believe that is new. News always reported all name changes.
tysonlowery
July 27, 2006 at 03:46PM View BBCode
It used to be somewhat iffy, it worked sometimes and sometimes it didn't. We're now storing every news item linked to every PlayerID in a new database table - so its cleaner and more efficient.Pages: 1