> Would adding SQL Indexes help to load the data faster?
Yes, very much so. But the COAPI deployment tool should have taken care of that for you when you deployed the type (depending on the version of FC... back in FC2 you had to do those manually). To be safe, maybe just check that your indices are configured correctly. > Is this a function of memory? It's always possible. are you out of memory on that server? How much have you dedicated to SQL? What's your DB size? Are you running out of space on the drive used by SQL? Are you truncating your SQL logs? Although this shouldn't have anything to do with wizard steps, one thing I do to help prevent server slowness is to make sure to purge the farLog table (for my clients I keep mine down to 1m records - depends on your server resources. I purge anything more than that nightly). Although the farLog shouldn't affect the wizard steps at all, its something to consider looking into anyway. If interested, I posted a copy of the nightly script I use to prune the farLog DB in this thread http://groups.google.com/group/farcry-dev/browse_thread/thread/c25b67fe5d908edd/c3314a22f65afd41?lnk=gst&q=farlog#c3314a22f65afd41 Regards, -- Jeff Coughlin On Feb 20, 2012, at 5:32 PM, Phil Lepanto wrote: > MS-SQL Server 2008. > > I thought it might be a case of having not imported TeaserImages from one > instance to the next, so I updated the database by setting the "studyImage" > field to null and dropping the index we had set on that field, however it is > still running surprisingly slow. > > 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? > > -Phil > > ++++++++++++++++++++++++++++++++++++++++ > Phil A. Lepanto > Chief Technology Officer > > -----Original Message----- > From: [email protected] [mailto:[email protected]] On > Behalf Of Nick > Sent: Sunday, February 19, 2012 12:31 PM > To: farcry-dev > Subject: [farcry-dev] Re: Custom Object takes forever to edit > > Hi Phil, > > What database are you using? I've had similar behavior with CF on Oracle due > to DB locks; usually as a result of uncommitted changes to a record in > SQLDeveloper. Usually there's no helpful error, CF just waits for Oracle to > release the lock > > -- > 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 > > -- > 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 -- 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
