Here is another one for those who havent used it like this yet

Don't use select * from table because it can be that the table you want to use is not open in this moment.

Try:
if !used("tablealias")
use table in 0 again alias tablealias
endif
select * from tablealias

I get a 10-100 times faster select command with this
If you use views try to collect the data through a much faster select only command, if you just search for something.
But very much faster is a scan for command instead of select in some cases.