Hi

I have been testing the cursoradapter class because I am thinking about using them in my business object. My reasoning is that it will make upsizing easier. However, at present I am using them with VFP tables. The problem is that the performance hit is substantial.

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 can only assume this performance hit will increase on busy or poorly configured networks.

So does anyone have suggestions for improving the speed of data retrieval? Perhaps using cursoradapters with native tables is a bad idea from a performance perspective despite the upsizing advantage.

Thanks
Simon