I have found that by using a secondary index, I can "walk" the database and 
copying the records which fit my criteria and write them a a created database 
much faster than by using a query! It seems odd but I did do a timing test on 
both approaches. The query took almost a full minute to complete and the 
script which "walks" the database took less than 10 seconds!
The database has about 20k records my secondary key is on a date field and I 
just want to select only current (that day's ) transaction;starting at the 
end of the database and going backwards. I really don't understand why the 
query takes so much longer. 
This is pdoxw 5.0. I was told that the query engine is far superior than the 
dos ver. Well is news to me! Or am I missing something in the query?
--- FLAME v1.1
---------------