Re: [firebird-support] Performing bulk update taking time.

2017-04-27 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
27.04.2017 9:03, 'Joje' j...@codework-solutions.com [firebird-support] wrote: > Is there a way through which this query can be further optimised as this > query taking time > for completion more than 3 -4 hours. Could I use batch based update in this > qu ery…? Query in FOR SELECT does not n

Re: [firebird-support] Performing bulk update taking time.

2017-04-27 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 27-4-2017 09:03, 'Joje' j...@codework-solutions.com [firebird-support] wrote: > Is there anyway using which we could perform bulk update in firebird. > > I have two tables A & B. Both tables are referenced by a *varchar(100)* > *AR_ID* column. > > - Total number of rows in each table

[firebird-support] Performing bulk update taking time.

2017-04-27 Thread 'Joje' j...@codework-solutions.com [firebird-support]
Hello everyone, Is there anyway using which we could perform bulk update in firebird. I have two tables A & B. Both tables are referenced by a varchar(100) AR_ID column. - Total number of rows in each table is around 1 million. Now in order to get faster result I created a bigint