>>If I need to show rows where Expires > datetime(), can I use SET KEY?
>
>SET KEY RANGE DATETIME(),{^9999-12-31}
>
>SET KEY require that index of Expires is the active one.
>in this case, SET FILTER is well optimized
>because the filtered rows are contiguous.
>The regeneration of the grid go in crisis,
>when the filter creates holes very long order
>active
Thanks, in my case the rows should be ordered by another date column, so SET KEY solution will not work for me. I'm thinking that most likely in my case there would be less than 100 rows anyway, so perhaps I should not worry now about SET FILTER. I will need to add an index on the EXPIRES, though, which I forgot to do.
Thanks.
If it's not broken, fix it until it is.
My Blog