Subject | RE: [firebird-support] Fast Inserting into GDB |
---|---|
Author | Rick Debay |
Post date | 2005-04-28T17:06:50Z |
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
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