Richard, it sounds like you might be able to implement the process I mentioned.
If you were able to determine a "baseline" processing time for a simple data set, you could use this to estimate the amount of time it would take for more complex data sets. You'd have to do a lot of testing to see how long different scenarios would take, and which things had what effect on the processing time. For example, if a certain variable exists it might take 10X as long as it would if that variable didn't exist. If you have a very complex processing task with many variables, this will be somewhat difficult...however, I think this would be your only option, as there isn't really a way (that I know of anyway) to pass back progress information from the server. Maybe you could try <cfflush> or something but I don't know if that could be captured by javascript, or what that would entail. And remember, even an estimated completion time is better than nothing at all, from the user's perspective. ----- Original Message ----- From: "Richard White" <[EMAIL PROTECTED]> To: "CF-Talk" <[email protected]> Sent: Monday, July 28, 2008 12:25 PM Subject: Re: jsmx and progress bar > Hi Josh > > we are doing something very complex actually that has so many different > things that could effect the time it takes. > > jsmx only passes back information when it is done but if we could get it > to pass back at various stages in the cycle then it would be perfect > > we are generating a spreadsheet with data but the data needs to be > processed and formatted with sql and cf and based on many many different > scenarios. > > currently the user selects to generate a spreadsheet and it says > 'generating spreadsheet...' but if they have selected a large amount of > data then it could take some time so we need to provide them with feedback > on the progress > > this is the issue we have right now > > thanks > > > >>What sort of thing are you doing on the server exactly? >> >>I don't think you can really get the exact progress, but you can do sort >>of >>an estimation that is better than nothing. >> >>I do this when doing multiple inserts into a database that can be a bit >>slow. You do a test single insert via ajax, record the time it took, then >>use that time to calculate the total estimated time for all inserts, and >>use >>that total time to do the progress bar. >> >>-- Josh >> >> >>> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309824 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
