|
JCapper Message Board JCapper 101
|
| Home |
Register
Log In |
| By | Propagating IV/Key Factors for UPR | |
| GUGA 5/23/2010 9:29:14 PM | Is there any difference, beyond speed of processing, in using SQL vs. playlist file KEY FACTOR REPORT results to propagate factors and IV into the UPR design module? And Jeff, if you happen across this post any chance of designing a Key Factor Report for ranks top2 and ranks top3??
| |
| jeff 5/24/2010 1:18:57 PM | Advantages of SQL Mode: 1. Data Window Speed - For me this all by itself is the deciding factor. Once the initial UDM foundation is there results in the Data Window come back in seconds (vs. minutes for playlist file mode) even when working with very large data samples. 2. Ability to make OR conditionals and math evaluations part of your UDM definitions. 3. Ability to link two or more UDMs together into a single UDM definition... and make the resulting UDM defintion require both UDMs to select the horse, or one UDM but not the other, etc. 4. Flexibility in testing - The SQL Language provides a great deal of felxibility. This makes it very easy (and fast) to test UDMs under a wide variety of conditions... surface, track, rider list, trainer list, sire list, start date, end date, odds and odds ratios, in combination with other UDMs, etc... all without changing the original UDM definition. 5. The SQL Mode HTML Report is fully customizable. Disadvantages of SQL Mode: 1. UDM defintions are limited to: a. Factors that are "native" to the StarterHistory Table (see the table schema for field names.) a. Plus 35 user defined factors. Meaning that you have fewer factors overall to work with and you to decide on a factor set to work with ahead of time. There's always the fear that you'll be "leaving something out." In my own case I beleive that concern is easily overcome by the advantages from working in sql mode. However, if "leaving something out" really is one of your concerns, you can work around that using multiple JCapper2.mdb files while maintaining multiple databases. -jp . ~Edited by: jeff on: 5/24/2010 at: 1:18:57 PM~
|
| Reply |
|
Copyright © 2018 JCapper Software back to the JCapper Message Board www.JCapper.com |