Hi everybody,
We're using MereMortals framework. We switched to VFP9 few days ago. We have one complicated form with lots of Business objects. When we save data in VFP8, it happens quickly. If we do the same in VFP9, it takes almost a minute to save.
We checked CPDBF() and CPCurrent(1) for every table in the database. They are all 1252. We disabled RI and it didn't make a difference. We're not using STR() in index expression. We do not have index on deleted().
We think the problem lies in Transaction handling, which is different in VFP8 and 9. We open transaction, then save parent BO, then save all the children, then close transaction. Each child is wrapped in its own transaction.
I think I read some threads here with the similar problem. Could you please point me out to them and also suggest, what could be wrong in our situatiuon?
For now we have to revert development back to 8 until we find the root of the problem and fix it. The current speed is unacceptable.
Thanks a lot in advance.
If it's not broken, fix it until it is.
My Blog