Hi
I create custom component for using in my application, instead of default
combobox. This component have 'All' property for all record in that
combobox.
I need to know which sql have better performance on large tables:
a. select ProductId, ProductName from Products where ProductId like
:ComboBoxSelectedValue;
In this case in combobox value for 'All' record is '%' and
is passed to query.
b. select ProductId, ProductName from Products where (-1= ProductId) or
(ProductId=:ComboBoxSelectedValue=;
In this case in combobox value for 'All' record is '-1' and
is passed to query.

I don't see differences on my development database. I have ~12000 products.
I intend to use this components for other fields, like orders or payments,
where I could have ~ 1-2 mil records in 1 year!

Thanks,
Paul



[Non-text portions of this message have been removed]