Tore,
The original queries are slow because they are not optimizable. As result all records in the table have to be read by the query. That's the primary reason for slowdown.
>
>please read this, I have written it a zillion times: You must NEVER, NEVER, NEVER us ANY reference to ANY object within a select statement!!!!!!!!!!!!!!!!!!!! The reason is that if you do, the search engine must evaluate this expression FOR EVERY RECORD in your table, in this case 6000000 items. This is the primary reason why this is slow!
>
<snip>
--sb--