- Community Home
- >
- Welcome
- >
- Other HPE Product Questions
- >
- Re: Using QC Interop.TDAPIOLELib.dll for MF QC ALM...
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-13-2017 06:23 AM
05-13-2017 06:23 AM
I am using Interop.TDAPIOLELib.dll for QC ALM Integration But taking too much time .
I am using Interop.TDAPIOLELib.dll for QC ALM 12 Integration and installed QcConnector.exe from tool link from QC ALM 12 on my 32 bit window machine.
I want to fetch all TestPlan with parent folder hierarchy . But its take too much time around 75 artifact of QC ALM (included Test Plan and Folder) taking 1 minute 50 seconds.
Private Sub LoadQCTree()
Dim rootNode As Object = Nothing
_treeManager = CType(_qcConnection.TreeManager, TreeManager)
Dim rootList As TDAPIOLELib.List = _treeManager.RootList
Dim rNode = rootList.Item(1)
rootNode = _treeManager.TreeRoot(rNode)
Dim FolderList As List = rootNode.NewList()
'Read sub node hierarchy...
RecurseTree(CType(FolderList, List))
ReadChildTestCases(rootNode)
End Sub
Private Sub RecurseTree(ByVal SubNodes As TDAPIOLELib.List)
For Each itm As SysTreeNode In SubNodes
Dim Description = CStr(itm.Description).Trim
If Not Description = "" Then Description = ConvertPlain(Description).Trim
AddNodeEntry(itm.Name, CStr(itm.NodeID), CStr(itm.Father.NodeID), "Folder", Description, Now, Now, "TestCase", "folder")
Dim children = itm.NewList
RecurseTree(CType(children, List)) ReadChildTestCases(itm)
Next
End Sub
Private Sub ReadChildTestCases(ByVal itm As SysTreeNode)
Dim testFilter As TDFilter = CType(_testFactory.Filter, TDFilter)
testFilter.Filter("TS_SUBJECT") = Chr(34) & itm.Path & Chr(34)
Dim TestList As List = _testFactory.NewList(testFilter.Text)
For Each test As Test In TestList
Try
Dim description As String = Convert.ToString(test.Field("TS_DESCRIPTION")).Trim
If Not description = "" Then description = ConvertPlain(description).Trim
Dim modifiedOn As Date = CDate(test.Field("TS_VTS"))
Dim CreationDate As Date = CDate(test.Field("TS_CREATION_DATE")) modifiedOn= Date.SpecifyKind(modifiedOn, DateTimeKind.Local) CreationDate = Date.SpecifyKind(CreationDate, DateTimeKind.Local)
Dim BaseId = test.Field("TS_BASE_TEST_ID")
Dim type = test.Field("TS_TYPE") AddNodeEntry(test.Name, CStr(test.ID), CStr(itm.NodeID), "File", description, modifiedOn, CreationDate, "TestCase", type)
Catch ex As Exception
'Do nothing..
'Current node will skip from the tree hierarchy
End Try
Next
End Sub
And also want to Fetch Requirements with folder hierarchy but its also taking to much time.
So , I'll try to improve performance using thread .
Thread 1 : Load all Test Plan
Thread 2 : Load all Requirement
and run parallel but i think is not supported parallel request. Because when i fetch requirement it takes 40 second (for 30 requirements) but fetch both parallel taking 1 minute 15 second for only requirements .
Please Help me to find out the way to how improve performance .
It is possible to get all test plan tree structure in one call.
Thanks
- Tags:
- SW
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-13-2017 02:29 PM - edited 12-23-2017 01:27 PM
05-13-2017 02:29 PM - edited 12-23-2017 01:27 PM
Re: Using QC Interop.TDAPIOLELib.dll for MF QC ALM Integration But taking too much time
This is the wrong company for MF software questions. You need to register in the MF Software Forum:
https://community.softwaregrp.com/
https://community.hpe.com/t5/Announcements/Software-Category-Blogs-Forums-in-Read-Only-May-9-15-2017/m-p/6962462
https://community.hpe.com/t5/Announcements/Software-to-split-from-HPE/m-p/6955457