Subject | Re: Performance Problem |
---|---|
Author | Adam |
Post date | 2007-08-29T12:51:17Z |
> 1. Before creating the user, it will check in the db whether user existsI am counting at least 4 round trips to the server here. Surely it
> or not. If user exists n the db, it will update the record otherwise a
> new record will be inserted.
>
> 2. Checks for the existence of the group, if group exists, then the user
> will be added to the group otherwise a new group record is created and
> the user will be added to the group.
>
would make more sense to do this as a stored procedure?
Adam