Hi Simon.

>For example I have a customer history file with roughly 300K records. I was assuming I would set a where condition in the SelectCMD so that as the user moves through the customer file they could see the account history and only the records for the current customer would be retrieved. This works but it takes much more time to retrieve the records (even with rushmore optimization) than my current method of using "Set Key to " to limited the records to the current customer.

I don't think this is a CursorAdapter issue but the difference between doing a SQL SELECT and accessing a table directly using SET KEY TO (which is extremely fast). So, yes, performance isn't a good in this scenario. However, if you were to upsize this app, you couldn't use that technique.

Doug