Slow processing

Hi everyone...

I have a problem regarding my company intranet. Some of my company web pages response very slow. I go through the source code written in cold fusion, and some testing on it, I found that the slow response is cause by heavy workload that the particular web page have to do like retrieving data, setting variables, and display the data.

What should it do so that particular web page to response faster and process or retrieving data faster.

Can you please only post a question once. Cross posting is very annoying.

http://forums.devshed.com/t82371/s.html
http://forums.devshed.com/t82422/s.html

What you are asking can't be written up in a simple message post, you are talking about application tuning. My general advice:

Optimize the database with indexes and views, including materialized views if necessary

Minimize nested loops

Minimize calls to external systems like LDAP or SOAP

Cache as much as you can, including database queries and content


hope that helps.