Can you use CursorAdapters instead of views? In my opinion it would be better and will give you more flexibility at the end. You may want to define your cursor adapter classes in prg (may be all in one prg). This way it would be easy for you to switch back-end.

So far I tested CA with MereMortals for non-updatable scenario (searches) and it worked very nicely.

BTW, do you know about bug in cCursor.IsNewAndEmpty method? For empty cursor it returns .t., while I believe it should return .f. We fixed it today in cCursor class.


>I currently have a database with 160+ tables and 300+ views. From what I have read separating these into tables only and views only databases is a help to performance. Compiling the views database into the application is also recommended. I also use Stonefield Database Tools.
>
>There are three issues I'd like to hear comments on before I embark on what I think is a long and arduous task.
>
>First am I correct in thinking that the the dataenvironment for each bizness object would have to be redone.
>
>Second the task of splitting out the views could be done through rebuilding the database from code.
>
>Third one is we use a program launcher to call the main program locally rather then on the server. Can the view database be compiled into the first called app called by the launcher program?
>
>Responses and suggestions would be appreciated.
>Thanks
>Jon