Question about search speed

[Ruslan Zasukhin]

On 1/28/13 6:22 PM, "jda" <jda at his.com> wrote:

Hi Jon,

But 

    SELECT * FROM T

Selects all records. No need for
  WHERE RecID <> 0

Sometimes we have show tip to select NONE records as
    SELECT * FROM T WHERE FALSE;

So by idea 

     select * 
    from myTable 
    where recID <> 0
    order by creation_dt desc limit 20

Is same as

    select * 
    from myTable 
    order by creation_dt desc limit 20


> Hi,
> 
> Because I need to select all records (and as you say, you can't get a recID of
> 0) and then sort them. As I said, this is a peculiarity of the UI I'm using,
> nothing for anyone else to concern themselves about. The code you suggested
> works just fine without the WHERE.
> 
> Jon
> 
> 
> Hi Jon,
> 
> glad you worked it out;
> However, how is it possible that you get Recid = 0 in a Valentina DB ???
> Otherwise put why do you do recid <> 0 ?

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