Oracle Database Report Slow

[Tumbler81]

Hello we have one problem.

We use in TestStand the Database Report Options. We write the Step Values in a oracle Database on a server. The Teststand sequence is running in the NI Operator Interface.

We have the following problem. Teststand needs after each passing longer to wrote the data in the database. After 24 hours, it takes up to 8 minutes. If we quit the operator interface and restart. The data back quickly in the database rub.

.

Is there somebody who knows this problem?

[Ken_Tobler]

Hello!

Which version of TestStand are you using?

Are you using a standard or your own TestStand model?

Which Database are you writing in? Are you using the standard tables or writing special results?

Is the database remote or local?

Which OI are you using (LabVIEW, CVI, VS)?

I didn't heard such problems with the standard settings in TS (standard model, standard tables,...).

Regards

Ken

[Tumbler81]

Hello kenT,

we using TestStand 4.0

we using the standard TestSTand model which ist a little modified.

The Database is a Oracle.

For the measurements we use the standard tables.

Only UUT_Result is modified

The databse is remote.

The OI is Labview

If we change to a local access database we have no problem.

On the attachment you can see the SequenceModel, Database Model an the Shema.