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