optimization via selection sets/indices

Bill Vermillion fp at wjv.com
Mon Oct 11 10:16:16 PDT 2004


On Mon, Oct 11 12:00 , while impersonating an expert on the internet, 
Robert Haussmann sent this to stdout: 

> We have a need to run real-time queries against a large
> database (2 million records).  Using rreport and 
> selection processing (-v) takes much too long.

I've found the -v processing with the indexed self-lookup is
faster than anything else I've used.

The first time I put that on a client computer one person ran the
report 3 times before coming to me and saying it didn't work.
The screen came back so fast he assumed that nothing had worked.

Granted it was far less than 2 million, but depending on how you
have things indexed it can be blazingly fast.   

Bill
-- 
Bill Vermillion - bv @ wjv . com


More information about the Filepro-list mailing list