Subject Re: Performance Problem
Author Adam
> 1. Before creating the user, it will check in the db whether user exists
> 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.
>

I am counting at least 4 round trips to the server here. Surely it
would make more sense to do this as a stored procedure?

Adam