Slow SharePoint query file dependency

[ArjoHP]

I have set up Framemaker 10 with SharePoint 2010. I can make a CMS connection without problem and have uploaded a number of books.

I can check in/out individual fm books and files without a huge delay (although performance is not good).

When I attempt to check out a book and all of its dependencies there is a show stopping delay.

Additionally when i right click on a book in the Repository Manager and select Show Dependencies there is an equally long wait to show a list that only contains 24 entries (commonly 5 fm files and the rest are graphics imported by reference).

My guess is that the SQL query on the FMDependency column in the library is causing some kind of bottle neck. I can't be sure.

As the FMDependency column is a multi line entry I can't index this in the library so I cant get any performance improvement that way from SharePoint.

Has anyone else had a similar experience. Are there any tips that can be given when setting up the library in SharePoint for best performance?

[Guest]

In my experience, the dependency processing is a bit slow.  But other factors can make it extremely slow. These have more to do with the SharePoint connection than FM.

As a test, map a local drive to your SharePoint resource (eg http://SharePointSite/yourSite) and copy in some smallish files (say a few jpg files) from somewhere else.  If this is noticeably slow:

1. Open Internet Explorer > Tools > Internet Options.

2. Select the Connections tab.

3. Click LAN Settings.

4. Ensure that "Automatically detect settings" is NOT selected.

I don't know why this causes slow SharePoint access, but it has been widely reported.

Also, if you're using ESET antivirus, disabling http traffic scanning can improve SharePoint response times greatly (for webdav access anyway).

[ArjoHP]

Thanks very much for your response.

I have tried the IE "Automatically detect settings" toggle without any performance gain.

File access through a mapped drive is fast, particularly if I map it using a UNC path with DavWWWRoot.

I have tried entering the UNC path into Framemaker's connection manager, but it does not allow back slashes so I have specified an HTTPS address using forward slashes. Frame seems to interpret various combination of back slash as being special characters such as bullet points etc.

Are there any work around's for entering a UNC path into the SharePoint Connection Manager in Frame?

Accessing files and data directly through the SharePoint web site is a breeze and very responsive. Ive downloaded a trial of FM11 to see if there are any improvements.

Are there any specific changes I need to make on the SharePoint library to allow it to work better with FM?

I have tried a couple of different work stations with different combinations of Anti Virus etc and these all have the same level of poor performance through Framemaker, but fast performance accessing SharePoint directly.

Do you have any other thoughts, they would be much appreciated?

Thanks

[Guest]

Just so you know, I'm not a tech support person, just a user who's had some experience with the SP connector.

When I suggested mapping a drive above, I should have given as an example \\SharePointSite\yourSite.  I don't know whether it would make any difference if you could use this form for the SharePoint Connector path.  The example in the SharePoint Connector dialog box explicitly calls for an HTTP address. This may be the required protocol for the SharePoint Client Object Model, which I would guess Adobe is using to make the connection.

I don't know of any other tips for speeding up dependency processing. I see a noticeable but not intolerable wait (perhaps 30 seconds for several dozen files.)  If you do find a way to improve this performance, please share it!  I'll be certain to update the list if I come across anything.

[Arnis Gubins]

FWIW, to enter a \ in FM you need to scape it with another \, e.g. "\\"

For UNC paths, you will need to have four backslashes to do a double-backslash.

[ArjoHP]

I have just tried escaping the slashes but unfortunately I get "Invalid URI: The hostname could not be passed". I tried various permutations of the path but always get this error.

I only seem to be able to enter a HTTP or HTTPS path in the SharePoint Connection Manager not a UNC. Is this others experience?

[Guest]

Yes, I tried double backslashes (\\\\ops\\documentation) and received the same error.

[Arnis Gubins]

This might be an error in the connector. I can use UNC paths in FM for geting at other types of content on various other machines in my network. I'd suggest reporting it as a bug via: https://www.adobe.com/cfusion/mmform/index.cfm?name=wishform&product=63

[Guest]

If the Connector uses the SharePoint Client Object Model, it would have to use a ClientContext constructor to establish the connection. The ClientContext constructor takes a URI as an argument. As far as I can tell, it does not support UNC paths.

[Arnis Gubins]

It's a documentation (lack of) bug, then.

This Help entry (point #3 "Specify the connection details") is probably the one that should have the "details" explicitly stated:

http://help.adobe.com/en_US/framemaker/using/WSb614a57911cb716533d97de012934e18ada-7ffa.html

You might want to make a comment on the Help page and possibly refer to this thread so that it might get updated with suffcient information to be actually useful.