SQL Question

[Ruslan Zasukhin]

On 7/24/06 2:03 AM, "Chuck Pelto" <cbpelto at pcisys.net> wrote:

>> No.
>> 
>> Because different kinds of queries return different kinds of cursors
>> "internally".
> 
> So, when they invented SQL they forgot how to simplify things and
> therefore, we have to deal with an additional layer of complexity

You need remember that SQL was invented first of all for access to
    REMOTE and MULTI-USER database.

You can do SELECT on table with Million records,
To server which is on other side of planet.

But you do not get this million, you get only e.. First N (20).
So much more effective do one more SELECT and send you next 20 records that
are fist in new order.


> when doing sorts of data by having to do another SQL SELECT
> call.....that's niiiiiice. [Note: If you're familiar with the old
> joke about the class reunion of the two southern belles, forgive my
> foul language.]
> 
> Okay. Next time you get a chance to talk to the people working on the
> next revision of SQL, I recommend you ask them to streamline the
> language by allowing for re-ordering of records in a cursor WITHOUT
> having to do a SELECT call again.

-- 
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]