Performance issues with large arrays

[rswaring]

I am working for a client who is generating very complex reports by using extremely large arrays. In some instances there is a 3-D array that gets to 100,000 lines long. I tried to look at it with cftrace and I was able to paste it into a Word document which ended up being 1300 pages long! It is hogging so much memory that the system grinds to a halt. They are resistant to putting this functionality into the database or any other change since it is so complex that a rewrite would take weeks. Is there a recommended limit on array size in Coldfusion 8? Any input appreciated!

 

[LyndonOHRC]

How could they be resistand to modifying code design "that the system grinds to a halt"?

Anywho....

See:

http://www.adobe.com/devnet/server_archive/articles/using_cf_variables.html

"Strings can be of any length, limited by the amount of available memory on the ColdFusion Server. There is, however, a 64K limit on the size of text data that can be read from and written to a ColdFusion database or HTML text area. The ColdFusion Administrator lets you increase the limit for database string transfers, but doing so can reduce server performance. To change the limit, select the Enable retrieval of long text option on the CF Settings page for the data source."



Lyndon

---People Remember about 10% of what you say ---They never forget how you made them feel. Covey

 

[rswaring]

Lyndon,

I totally agree! It belongs in the database. Thanks for the input.

Rebecca