Subject 回复: [firebird-support] Re: About update clause's time.
Author Yang Jin
Firstly,Thank you reply.
The way is the simplest way.I wrote'update Table1
set Afield = Avalue where Bfield > Bvalue' in IBExpert's 'SQL Editor'. The Afield is a integer type,Avalue is a const integer; Bfield is the PrimaryKey, Bvalue is a const integer.

Svein Erling Tysv�r <svein.erling.tysvaer@...> 写道:

--- In, Yang Jin wrote:
> hello,
> I update 27,000 records in a table with 300,000 records.I use
> primary key as only where condition, the whole execute time almost
> 2mins.If I update all records, the time is almost 6m.
> The database is dialect 3,the page size is 16K,ODS is 10.1,
>Execute update clause in IBExpert, Firebird1.52 as service.
>I want to know if the time can short.I hoep result is less 30 sec.

How and how much do you update? If you prepare the update query once,
then in a loop set the parameters and execute, 27000 records in 2
minutes sounds slow - that is only 225 records per second. I would
expect it to be possible to improve this considerably.



Visit and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at


Technical support Computer security Computer technical support Computer training Free computer technical support


Visit your group "firebird-support" on the web.

To unsubscribe from this group, send an email to:

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]