On Tuesday, 21 February 2012 09:32:29 UTC+11, Phil Lepanto wrote: > > In some cases, it will actually load the wizard step and you can step > through it albeit very slowly, but it isn't guaranteed that you can make it > to the end of all of the steps. > > Would adding SQL Indexes help to load the data faster? Is this a function > of memory? > Have you had any resolution to this issue? First thing would be to actually log the SQL statements and how long they take to run -- you can do this with SeeFusion/FusionReactor or SQL Server itself. If you have a SQL statement red-handed then it will be a lot easier to optimise.
On the other hand it may not be SQL at all and something else in the step. Those sorts of wait times (>200secs) are unheard of here, and we have some wizards larger than what you describe. It's the sort of wait time that suggests some kind of network or third-party activity that is not responding. Anyhoot -- hope all is well, -- geoff http://www.daemon.com.au/ skype. gb.daemon twitter. @modius -- You received this message cos you are subscribed to "farcry-dev" Google group. To post, email: [email protected] To unsubscribe, email: [email protected] For more options: http://groups.google.com/group/farcry-dev -------------------------------- Follow us on Twitter: http://twitter.com/farcry
