Question about search speed

[jda]

Hi Ruslan,

I wish I'd never shown my code...

Trust me, I need it for what I'm doing in my app (and it's not worth my time or yours to go through it).

Somebody, next issue, please!

Jon
Sonny Software


> 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]
> 
> 
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina