Re: [firebird-support] What is more effective execute block or select?

 

On Wed, 27 Jan 2016 23:01:50 +0100, "setysvar setysvar@gmail.com
[firebird-support]" <firebird-support@yahoogroups.com> wrote:

> [..] On the other hand, there are cases
> where EXECUTE BLOCK can help performance (note, I speak for 2.5, I know
> nothing about Firebird 3):
>
> UPDATE <HugeTable> h
> SET <AField> = (SELECT <AnotherField> FROM <TinyTable> t WHERE
> h.<SelectiveIndexedField> = t.<SomeField>)
>
> is much slower than
>
> EXECUTE BLOCK AS
> Declare variable a integer;
> Declare variable b integer;
> BEGIN
> FOR SELECT DISTINCT <SomeField>, <AnotherField>
> FROM <TinyTable>
> INTO :a, :b do
> UPDATE HugeTable
> SET <AField> = :b
> WHERE <SelectiveIndexedField> = :a;
> END

Out of curiosity: have you also compared this with using MERGE?

Mark

__._,_.___

---

Posted by: Mark Rotteveel <mark@lawinegevaar.nl>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (5)

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit Your Group

• New Members 1

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___