We've added SQL indexes to the Object ID and the Version ID to the object in question.
The database the site is using is less than 10MB, the database server has about 18GB available of free space, and we are only storing about 6 weeks of SQL Logs. For the most part, other objects in this installation run quite smoothly, load times per wizard step are about 2.5 seconds whereas this object typically takes about 110 secconds per step to load. I looked at the farLog table, at this point we're only looking about 700 records in that table. I'll try to pick this apart and give you guys more to go on as the day progresses. -Phil ++++++++++++++++++++++++++++++++++++++++ Phil A. Lepanto Chief Technology Officer From: [email protected] [mailto:[email protected]] On Behalf Of Jeff Coughlin Sent: Monday, February 20, 2012 05:52 PM To: [email protected] Subject: Re: [farcry-dev] Re: Custom Object takes forever to edit 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]> [mailto:[email protected]]<mailto:[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]<mailto:[email protected]> To unsubscribe, email: [email protected]<mailto:[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]<mailto:[email protected]> To unsubscribe, email: [email protected]<mailto:[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]<mailto:[email protected]> To unsubscribe, email: [email protected]<mailto:[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
