R04575 - running slow


Active Member

The report R04575 is running really slow. Couple of
months before it used to take 6 to 7 hours to
complete. Now it takes couple of days to complete.
Could you please give some tips in fixing this. Your
help is greatly appreciated.
We are in B7332 SP11.3 SQL-7.0/NT

David S



Active Member
It's either specs or data at fault, assuming your config is up to scratch.
Does it take that long in every environment?
Review the state of your indexes on the tables the report uses (in each
environment). Try using the update statistics command, regenerate the
indexes, or create new ones as needed.

How many cheques are you updating at a time? This ube has always been slow,
but I have never seen it be that slow. I have seen payment groups of a
couple of thousand cheques take 6 - 7 hours to update under B732.2. We are
now on Xe and the speed has improved considerably. This doesn't help with
your problem but hopefully gives you a guide.


Marty Fleming
Business Analyst
Richmond Limited

Phone: +64 +6 8786464 Ext 8168
Fax : +64 +6 8780959
Email: mailto:Marty.Fleming@Richmond.co.nz
Web Page: http://www.Richmond.co.nz/

Site Specifications
OneWorld: Xe
Database: Oracle 8i
Enterprise Server: Intel NT
Clients O/S: NT