On Wed, Jan 21, 2015 at 11:04 PM, Stephen Russell <[email protected]> wrote: > Resist the URGE to put a UDF() into all SQL statements. > I am taking out Rtrim(LTrim( st.item )) = Rtrim(LTrim(tp.item)) now just > st.item = tp.item in queries that drops my time fro 7 seconds to .1 second > on sub-million row tables. > This demands evaluation on the row level and tosses out all the benefits of > using indexes. I inherited this crap from years of "poor" accounting
Indeed. Rushmore optimization is important for searching large DBFs, and UDFs can make that unusable. -- .~. Might, Courage, Vision. SINCERITY! / v \ 64-bit Ubuntu 9.10 (Linux kernel 2.6.39.3) /( _ )\ http://sites.google.com/site/changmw ^ ^ May the Force and farces be with you! _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CAGv=MJA6TjKr-xaXtxrHW2pbwgAte-9r=ddn6dhmk0s7afu...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
