Fine Tuning

[Ed Kleban]

On 11/18/05 1:59 AM, "Ruslan Zasukhin" <sunshine at public.kherson.ua> wrote:

> On 11/18/05 9:10 AM, "Ed Kleban" <Ed at Kleban.com> wrote:
> 
>>> In fact, if you use SQL and cursors, then you can SELECT e.g. 3 fields from
>>> 20. Then cursor will iterate 20/3 = 7 times faster.
>> 
>> Ah, very good point.  I hadn't thought about that.  I was intentionally
>> avoiding SQL accesses in favor of the native API based on presumed superior
>> efficiency.  But yes, I see now.
> 
> That is the point. We have realize too late that API Vtable do not have
> mechanism as Vcursor have. So we have come to idea of lazy reading.
> 

Good idea.  We likely to see it within a year?

> 
>> SQL has the expressive power to limit the
>> work done if your SQL parser is smart enough to code it well -- which you've
>> just told me Valentina's is.  Makes sense.  You'd want to optimize the heck
>> out of this since that's how the majority of the world would access the
>> tables.
>> 
>> Ok, Delving into SQL will be next on my study list.  I believe in a previous
>> email I saw you comment that you cant do a search on cursor results, but
>> rather you can build a new table if need be.  My intended approach had been
>> to do Find extracts to VArraySets; but if if SQL provides me either with
>> that or the ability to make interim temporary tables, either of those should
>> be just dandy.
> 
> You can MIX.
> Some task do in API, some in SQL

I intend to.

> 
> FYI: In c++ developers have much more tools to work with.
> Just no sense open that tools e.g. V4RB. Or it is hard technically.
> 
> For example, in C++ you can iterate single column applying some action.
> 

Good to know.  My approach is to go as far as I can in my environment of
choice where I'm productive, RB in this case, and then look for ways to
optimize outside the environment later... such as writing a plugin in C++
that could provide additional performance.   -- A common appropach.

When I looked on the Paradigmasoft.com site in the document section the last
couple times I never found the C++ API documentation.  What's the document
name?