I assume you're talking about a stored procedure. You don't want a
round trip to the client each time with the exception.

You can also do this in a stored procedure:

UPDATE TABLE
IF (ROW_COUNT = 0) THEN
BEGIN
INSERT INTO TABLE
END

Let us know which is faster.

-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of robertgilland
Sent: Thursday, April 28, 2005 2:50 AM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Fast Inserting into GDB

Would this be a safe way of accelerated input into a TABLE.

TRY
INSERT INTO TABLE
EXCEPT
UPDATE TABLE
END;



Would this cause Firebird Server to get upset by having to generate
exceptions all the time.

Regards,

Robert







Yahoo! Groups Links