Updatable view questions
Posted: Sat Aug 22, 2009 1:18 pm
Hi,
I have an application that is integrated with IPB.
I'm going to upgrade the IPB version to 3
The problem is that in IPB 3 members.id is renamed to members.member_id and this breaks all queries, that use the members table.
To avoid rewriting queries, I came up to this solution:
As far as I know, where there is 1:1 mapping you can insert, update and delete records, using the view as a reference. I've already tried with update statement. But I have no experience, so I have 2 questions:
* Are there any queries, that can fail, using this view
* How this will reflect to the performance of the site?
I have an application that is integrated with IPB.
I'm going to upgrade the IPB version to 3
The problem is that in IPB 3 members.id is renamed to members.member_id and this breaks all queries, that use the members table.
To avoid rewriting queries, I came up to this solution:
Code: Select all
rename table ibf_members to ibf_members_master;
create view ibf_members as select *, member_id as id from ibf_members_master;* Are there any queries, that can fail, using this view
* How this will reflect to the performance of the site?