SQL Server Performance

Update/Insert with Views

Discussion in 'Performance Tuning for DBAs' started by vvkp, Feb 22, 2005.

  1. vvkp New Member

    Hi frineds,
    We are using multiple databases (SQL Server) in our application (J2EE) . Our connection is always to the main DB & Our client wants us to use VIEWS whenever we update or insert into the other databases. Is this a recommended way? Will there be performance impact owing to this? Their point is, it gives them the freedom to change the name or schema of the other DBs and allowes our application to be not tightly coupled to the other DB params.
    Thanks in advance
  2. mmarovic Active Member

    Sorry vvkp, I haven't read your post carefully first time I posted the answer. Are all your dbs on the same database server? For schema changes stored procedures or views for select and procedures for update/insert/delete is better solution. However if they want to be able to change database names, I am not quite sure...

Share This Page