Efficiency of parameter handling

[Robert Klemme]

Hi,

I have this SP:

CREATE DBPROC insert_error_recipient(
  IN a_event_id   FIXED(12),
  IN a_recipient  VARCHAR(64) )
AS
VAR
  l_userid     FIXED(9);
BEGIN
  CALL get_or_create_user_id( :l_userid, NULL, SUBSTR(:a_recipient,
1, 64), NULL );
  INSERT INTO cr_admin.ag_outbound_error_recipients ( eventid,
indexid ) VALUES ( :a_event_id, :l_userid );
END;

Now, since SUBSTR will always extend the string to 64 characters, I
imagine this variant might be more efficient:

CREATE DBPROC insert_error_recipient(
  IN a_event_id   FIXED(12),
  IN a_recipient  VARCHAR(64) )
AS
VAR
  l_userid     FIXED(9);
BEGIN
  IF LENGTH(:a_recipient) > 64 THEN
    CALL get_or_create_user_id( :l_userid, NULL, SUBSTR(:a_recipient,
1, 64), NULL );
  ELSE
    CALL get_or_create_user_id( :l_userid, NULL, :a_recipient, NULL );
END;
  INSERT INTO cr_admin.ag_outbound_error_recipients ( eventid,
indexid ) VALUES ( :a_event_id, :l_userid );
END;

What do the insiders say?

Kind regards

robert

--
Have a look: http://www.flickr.com/photos/fussel-foto/

--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]