Fine Tuning

[Ruslan Zasukhin]

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.


> 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

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.


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]