Calculating running totals

[phellis]

I have a table with multiple rows where users can enter a number on weach row. I had a running total that gets calculated each time the user changes a value which was done by looping through the values. However although this works well with 20 or so rows it starts becoming slow when doing 200 rows.

I have changed my page so that the total only gets calculated when the user presses a button now, again using the looping method. Hoever it takes approx 5 seconds to do this.

Is there a faster/better way to calculate the total value?

 

[theboyhope]

Maybe your loop could be optimised a bit. Lots of maybe's cause you haven't really told us much about how you're doing this.

Can we see the page?