|
JCapper Message Board JCapper 101
|
| Home |
Register
Log In |
| By | SQL mode | |||
| Windoor 6/12/2011 12:16:22 PM | I'm just now getting around exploring the possibilities with SQL. At first glance, I saw no real benefit, except for speed of running queries. Now it looks like this is the only way to use the “OR” statement. True? If so, is there a quick and easy way to convert UDM’s over to SQL? Are there other benefits I’m not seeing just yet? Regards, Windoor.
| |||
| GlennF 6/13/2011 8:14:24 AM | there are vast differences between playlist and SQL modes. IMHO SQL is MUCH the superior, although it takes some time to learn all the little tricks. To really make best use of the advantages and differences of SQL I would suggest starting from scratch and not try to port playlist UDMs. I did, and I don't have the slightest regrets.
| |||
| Charlie James 6/13/2011 4:29:04 PM |
Yes. It's the only way I'm aware of to use OR in a udm. Agree with GlennF = Instead of attempting to replicate existing playlist udms, after you know your way around and can take advantage of what sql offers - sql udms will take you farther... much farther. Benefits you might not have thought of beyond query speed: *=using math operators - example: AND (ODDS > 0 AND UPROpinionProb > 0 AND ODDS >= (((1/UPROpinionProb) - 1) * 1.05)) ...the above expression creates an oddsline on the fly and makes it part of the UDM, and then sets the min overlay required at +5% *=using OR in creative ways: for example wrapping multiple udms in parenthesis characters meaning that you now have single udms acting as the intersection of multiple udms... ...or using OR to match specific runstyle with specific riderlist, etc. inside a single udm... Not to be too much of a jcapper cheer leader but sql sets your imagination as the limit not the software. ~Edited by: Charlie James on: 6/13/2011 at: 4:29:04 PM~
|
| Reply |
|
Copyright © 2018 JCapper Software back to the JCapper Message Board www.JCapper.com |