I have 2 machines, hardware config almost same, same CPU and speed, same OS and Informix version, production has 8 CPUs, 10GB RAM, test server has 6 CPUs, 4GB RAM. use backup/restore make two machine have same data. compared OS level copy file speed, same.
run a create index scripts on test server takes 20 minutes while on prduction needs 4 hours. What should I think into for this very slow rebuild index on prduction machine?
Message was edited by: Bing_Liu
NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
This topic has been locked.
2 replies Latest Post - 2008-10-24T18:43:43Z by SystemAdmin
Pinned topic What should I think of this very slow rebuild index?
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2008-10-24T18:43:43Z at 2008-10-24T18:43:43Z by SystemAdmin
Soccer-Ball 2000000SWX3 PostsACCEPTED ANSWER
Re: What should I think of this very slow rebuild index?2008-03-24T19:06:21Z in response to SystemAdminIt is interesting that you say "Same data " ???
Is that same volume of data also. So exact same table schema with same exact number of rows and same exact data loaded in test as in production? Four hours vs. 20 Minutes this is a huge difference.
What threads are running on IDS for 4 hours (onstat -g act -r 2) (onstat -g ath).