Somebody can help me to impove the efficiency, or the situation is normal in Firebird?
Hope some reply!

Yang Jin <ojinyang@...> 写道：
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@...> 写道：
Hello!

--- In firebird-support@yahoogroups.com, 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.

Set




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

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

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




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

---------------------------------
YAHOO! GROUPS LINKS


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

To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com

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


---------------------------------




---------------------------------
DO YOU YAHOO!?
雅虎免费G邮箱－No.1的防毒防垃圾超大邮箱

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



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

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


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

To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com

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


---------------------------------




---------------------------------
DO YOU YAHOO!?
雅虎免费G邮箱－中国第一绝无垃圾邮件骚扰超大邮箱

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