Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.

Bug 399637

Summary: SFTP Drives really slow down file service queries
Product: [ECD] Orion Reporter: Anton McConville <antonm>
Component: ClientAssignee: John Arthorne <john.arthorne>
Status: RESOLVED FIXED QA Contact:
Severity: normal    
Priority: P3 CC: ken_walker, mamacdon, simon_kaegi
Version: unspecified   
Target Milestone: 2.0 RC1   
Hardware: PC   
OS: Windows 7   
Whiteboard:

Description Anton McConville CLA 2013-01-31 10:02:06 EST 
I've noticed that calls to the regular Orion file-service are very slow when I have SFTP drives attached. It's pretty much unusable - in the range of 10s of seconds for a navigation tree to render - Simon and I measured 13 seconds for a call when I showed him. 

When I disconnect the drives the Orion file-service speed returns to normal again.
Comment 1 Ken Walker CLA 2013-02-05 16:37:18 EST 
I don't seem to have any sftp drives anymore on OrionHub however I did use the Server Link action a while ago (after M2) to try it out.  Now my OrionHub file system is very slow. I ran the network tab in Chrome and saw it takes 14 seconds to get my info.  In the response I see the following and I'm not sure what the "Projects" structure is.

Children: [{ChildrenLocation:/file/kwalker/Tutorial/?depth=1, Directory:true,…},…]
  0: {ChildrenLocation:/file/kwalker/Tutorial/?depth=1, Directory:true,…}
  1: {ChildrenLocation:/file/kwalker/dbchooser/?depth=1, Directory:true,…}
  ChildrenLocation: "/workspace/kwalker"
  Directory: "true"
  DriveLocation: "/workspace/kwalker/drive"
  Id: "kwalker"
  Location: "/workspace/kwalker"
  Name: "Orion Content"
  Projects: [{Id:Ci, Location:/workspace/kwalker/project/Ci}, {Id:no,  Location:/workspace/kwalker/project/no},…]
    0: {Id:Ci, Location:/workspace/kwalker/project/Ci}
    1: {Id:no, Location:/workspace/kwalker/project/no}
    2: {Id:BU0, Location:/workspace/kwalker/project/BU0}
    3: {Id:Bls, Location:/workspace/kwalker/project/Bls}
    SearchLocation: "/filesearch?q="
Comment 2 Anton McConville CLA 2013-02-05 16:43:45 EST 
On the other hand, I have SFTP drives connected again, along with my orion content and I'm no longer seeing the issue.

I did have problems with it at home last night. It may have been coincidental, but I unloaded a Google Drive plugin that I had, cleared everything and restarted chrome - speed seemed normal after that.

I'll keep my eyes open - let me keep developing with SFTP drives connected for a few days.
Comment 3 John Arthorne CLA 2013-02-06 15:54:32 EST 
We were contacting the drive to get the project timestamp, but then discarding the information if remote drives were not requested. I made a simple optimization to avoid contacting drives when not required.

http://git.eclipse.org/c/orion/org.eclipse.orion.server.git/commit/?id=baf184729b7eba84e9e4fe2d53cbf4f20dd52d27