>Hi All,
>
>I have a form with a 4-page pageframe, using a private datasession. In most cases, there are about 10-15 views open - most for lookup and populating lists, 4 for writing to data. Most times, the form works fine.
>
>However, in one situation, I open about 3 dozen more views. In particular, when deleting an object, I create a very deep containership hierarchy of business objects. Each business object checks it's contained objects to be sure that the deletion is OK to run. These objects then check their contained objects, and so on. This results in literally dozens of views being opened. The contained objects don't instantiate until needed (i.e. for the deletion). (I'm using Mere Mortals, and Mere Mortals Business Objects.)
>
>After performing this deletion, performance slows to a crawl, and the only way to restore it is to exit out of the app (or VFP) entirely.
>
>My initial thoughts were a dangling object reference, and I still leave that open as a possibility, but I can't find it anywhere.
>
>Does anyone else have any other ideas? Alternatively, any thoughts on how to find a dangling reference?
>
>Thanks,
>
>David
>
>(I'm also posting this message under The Mere Mortals).

Closing and re-opening tables or views is slow. If you open them at startup (or keep them open after opening them) things should go faster.

Another idea that occurs to me is that it might be better to leave the "delete OK?" issue to the database design, that is, use referential integrity.