We have 10 web sites running and having 10 database stored in same server .
i need to check in all the 10 database that particular id has repated .
if it is repated i should not allow the user the create that id .
as it is we have 100k qry hitting the database per minute .. so have some performace issues .
if i write code to connect all the database is same file . will there be any performance issue .
or is there any other method to do that ...
Quote:
Originally Posted by rashmiks
Hi ,
We have 10 web sites running and having 10 database stored in same server .
i need to check in all the 10 database that particular id has repated .
if it is repated i should not allow the user the create that id .
as it is we have 100k qry hitting the database per minute .. so have some performace issues .
if i write code to connect all the database is same file . will there be any performance issue .
or is there any other method to do that ...
Hi there,
Kindly refer to below attached link. Please do not double post. Take care
Trigger
No comments:
Post a Comment