I've stumbled onto something mighty interesting with Oracle joins, and I'd like someone to perform the same thing in MySQL: select count(e.game_id) from events...
61
tangotiger
May 9, 2008 5:59 pm
I'd appreciate anyone with a MySQL database to run those two selects, and report back on elapsed time. Thanks, Tom ... The Book--Playing The Percentages In...
62
Mat Kovach
matkovach
May 9, 2008 6:06 pm
... I am rebuilding my database server (finally got faster and larger drives). I'll give a shot on Saturday, along with a test on Postgres....
63
tangotiger
May 9, 2008 8:12 pm
... Great thank you. I asked on an Oracle board, and in order to better utilize the index, the column being indexed should be noted as NOT NULL. I'll try it...
64
tangotiger
May 10, 2008 2:43 am
I'm just working something out for pitch sequencing. Let me know what you think. The requirements are: 1. We need to know which counts the event went through....
65
tangotiger
May 10, 2008 2:51 am
... Note that while we'll know the counts entered, we won't necessarily know the sequence. For example, if you go: 0-0 0-1 0-2 0-2 0-2 1-2 1-2 1-2 The 0-2...
66
wyerscj
May 10, 2008 3:14 am
... major and ... by 'password' ... Mat - I tried it the other night and got mixed results, but I was trying to use data I had already spidered using another...
67
Brian L Cartwright
brianlcartwr...
May 10, 2008 3:32 am
CWGAME parses the date as one field. In most frequently refer to year, and don't want to do any parsing in SQL, so in my post-processing, I have split the date...
68
Theodore Turocy
arb1ter
May 10, 2008 3:36 am
On Fri, May 9, 2008 at 10:32 PM, Brian L Cartwright ... No. cwgame operates the same way that BGAME does, and that's not negotiable. Ted -- ...
69
Mat Kovach
matkovach
May 10, 2008 1:27 pm
... I should have pointed out a few things: The current code will along work with 2006 and up files. Before that they had a file game.txt that contained...
70
tangotiger
May 10, 2008 2:22 pm
... My intention is to make EXT_GAMES and EXT_EVENTS for all those fields that I want to add that Chadwick doesn't generate. For example, the EVENT_CD I will...
71
Theodore Turocy
arb1ter
May 10, 2008 2:50 pm
... You mean game_id and not game_dt here, right? Ted -- drarbiter@... - AMDG Chadwick: Open Source Tools for Baseball Play-by-Play -- ...
72
tangotiger
May 10, 2008 4:29 pm
... Oops... correct. Tom...
73
Brian L Cartwright
brianlcartwr...
May 10, 2008 7:08 pm
This is another field that could be included as an extended field of the games table, LeagueID for visitor and LeagueID for home. Right now in Access, I have...
74
Theodore Turocy
arb1ter
May 10, 2008 7:11 pm
On Sat, May 10, 2008 at 2:08 PM, Brian L Cartwright ... This is in cwlog already. I recommend everyone have a look at the Retrosheet gamelog spec, and ask...
75
tangotiger
May 10, 2008 7:20 pm
... That's a good one. I usually just care about whether the DH is in effect or not for that game. I don't particularly care about NL/AL. But, no problem to...
76
Brian L Cartwright
brianlcartwr...
May 10, 2008 7:37 pm
... This is in cwlog already. I recommend everyone have a look at the Retrosheet gamelog spec, and ask whether there's anything missing from *that* list that...
77
Theodore Turocy
arb1ter
May 10, 2008 7:42 pm
On Sat, May 10, 2008 at 2:37 PM, Brian L Cartwright ... My point is the gamelog specification (and cwlog), and not BGAME, should be the starting point for the...
78
Brian L Cartwright
brianlcartwr...
May 10, 2008 9:00 pm
... I'll agree that we were going the route of CWGAME populating the game table, and CWEVENT populating the event table. As I am writing some SQL routines I'm...
79
tangotiger
May 11, 2008 12:40 am
... Good suggestion. It'll be worthwhile for me to create the column names for GAMELOGS and add that to our Database. I'll work on that during the week. Tom...
80
wyerscj
May 11, 2008 3:30 am
... trying to ... again ... that ... of ... file ... that ... parser ... fields ... appreciative. ... the ... are ... Here's what I get: ...
81
Brian L Cartwright
brianlcartwr...
May 11, 2008 10:59 pm
sort of thinking out loud here...but as I consider Ted's comments, and continue to do production work with my Access database (pre Tom's schema) I came to...
82
Brian L Cartwright
brianlcartwr...
May 11, 2008 11:09 pm
Sent: Saturday, May 10, 2008 12:29 PM ... Although in Access the function is "mid" Brian...
83
Mat Kovach
matkovach
May 12, 2008 4:45 pm
... Yea, download all the files without a problem. ... Everything should now be loaded into the database. You should be able to check MySQL now and see all...
84
wyerscj
May 12, 2008 7:20 pm
... mlb - ... The data is in place for the games that the parser went through, yeah. But I didn't specify a date value - do I need to run the program ...
85
Mat Kovach
matkovach
May 12, 2008 7:50 pm
... At this time, yea. But this little batch script should be able to catch one up to the end of April. @echo off set month_end=4 set day_end=31 ... if %month%...
86
tangotiger
May 13, 2008 1:44 am
... and I'd ... You can do an "ANALYZE" in Oracle that helps the optimizer. Once I did that, the first select ran in 4 seconds. Needless to say, optimization...
87
Dan Nichols
dan_nichols
May 13, 2008 2:14 am
I'm trying to follow the instructions on Tango's wiki and ran into a problem. I got all the retrosheet zip files downloaded and unzipped. I grabbed the version...
88
Theodore Turocy
arb1ter
May 13, 2008 2:53 am
Yes. Extended fields 51 and 52 are only available if you pull down the source from the development subversion repository. I'm not in a position to build...
89
Mat Kovach
matkovach
May 13, 2008 5:13 pm
Here is what I got for MySQL: +------------------+ ... +------------------+ ... +------------------+ 1 row in set (11.62 sec) mysql> select count(e.GAME_ID)...
