Mike Yearwood
Toronto, Ontario, Canada
General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>Hi Mike,
>
>Interesting idea, but I think only partially possible here. The udf's are not very complex and nearly always either working on a single string or returning info about that string. Removing the overhead of function calling IS tempting. Concatenating the pure expressions via snippet engine should should give a boost. I partially use a similar approach with properties (giving me the benefit of inheritance and fast inspection via property sheet) and a query expressoin rule table, but your recursive approach is definitely at a higher level. While I believe some of the transformations are at least easier to code as udf: removing double letters for instance, I will at least the test of manually flattening the with only expressions into one big expression simulating the performance gains. Still - I don't see the need of the optimizing behavior vfp shows.
I'd agree with that, except that if VFP optimized UDFs, there would be a ton of complaints where someone's UDF was misbehaving and they'd blame VFP and call it buggy.
>
>thx for the nudge
>
>thomas
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only