Inserts are by far the quickest, as no-one else can have the new record
(that doesn't exist yet) in their transaction context.

For this reason also, updates can fail, if someone else has commited a
change to the same record you're using, and you go to commit, you'll get an
update conflict.

N.

> -----Original Message-----
> From: firebird-support@yahoogroups.com
> [mailto:firebird-support@yahoogroups.com]On Behalf Of NAS
> Sent: Friday, 30 December 2005 12:44 PM
> To: firebird-support@yahoogroups.com
> Subject: [firebird-support] Performance insert and update
>
>
> Hi
>
> what is the better performance procces insert or update may
> be anyone
> have calculated ?
>
> nas
>
>
> ------------------------ Yahoo! Groups Sponsor
> --------------------~-->
> Get Bzzzy! (real tools to help you find a job). Welcome to
> the Sweet Life.
> http://us.click.yahoo.com/KIlPFB/vlQLAA/TtwFAA/67folB/TM
> --------------------------------------------------------------
> ------~->
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
> __________ NOD32 1.1344 (20051229) Information __________
>
> This message was checked by NOD32 antivirus system.
> http://www.eset.com
>
>