How can I query TestStand Database quickly?

[yangyang-rexxar]

Hello everybody:)

I have a performance issue with default TestStand database what puzzled me for long time.

In default database TestStand organize the different test item to different table, if I want to query a test record according to a special Serial Number, the query will look into UUT_RESULT at first to find a GUID then forward to the other table to find a series of GUID bound with this SN which will be used to go into different tables like a numeric values table or pass_fail table to find out the result of each test step.

Half a year ago, we have a small tool embeded with customized TestStand Interface to access this SQL Server 2005 Express database to fetch a SN and all its test results details for faulty analysis. Recently I found it will cost me more than 2 minutes to fetch all related test results of one SN, I tried to write some query in SQL SERVER management studio to get the same thing, the case is still there. And also I check the tables, all tables are already indexed, so I'm quite confused.

Did someone meet similar thing with me? Can you provide some suggestion on this?

[Dennis_Knutson]

What exactly is the query that you are using? Depending on how many records you are attempting to retrieve, two minutes may not be unreasonable. If the database is on a network share, if others are attempting to do similar, large queries, can also affect performance. Making your query into a stored procedure could save some time.