Hi all I have a program that I have been asked to modify and enhance.
This is easily done (well relatively easy) but I would like to get some feedback re the way the program is currently structured. The application uses a MSSQL database to store information. Currently Stored Procedures are not used at all in the entire application. The application runs on a CF7 standard platform and IIS. There are no CFCs used in the application. All queries are used "inline" Now for the interesting part. Lets say the program is supposed to display a list of salesmen and their sales for Jan, Feb & Mar So in the program there is a header line to list what each column of the display is. Then the detail lines there are <tr> <td>query get salesman</td> <td>query get salesman and jan figures</td> <td>query get salesman and feb figures</td> <td>query get salesman and mar figures</td> </tr> then a total line So basically everytime a line is produced for a salesman then the queries are run. This to me seems would be one reason why the program takes a long period of time to run. Queries are being run multiple times which seems very inefficient. Just wondering what others think. Regards ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287480 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
