Create one statement for databse logging as apposed to data across numerous tables.

[Roons1159]

As more and more data flows into my database, I am having more and more trouble joining/indexing them to get fast results.  As apposed to having separate statements, is there a way to create one statement that has all the information I need/want as apposed to indentifying them by thier ID and joining tables.  I thought this would be as easy as copying expressions from one statement into another and creating the assoicated columns in that specific table.

Example:

How would I get "Logging.StepResultProperty.Limits.High" (which is the "High_ Limit" column in the MEAS_NUMERICLIMIT statement) into the UUT_RESULTS statement so there is only one table.

[~jiggawax~]

Let me see if I understand what you are saying:

Basically you want to take all of the information that is logged to the database and create one table that will log all this information?  So 1 database with 1 table in it that contains Recordsets and Fields for all of the different information you can store when executing sequences?

The tables are created by your schema.  The default schema is set up to minimize disk usage.  If you had one table that had a Recordset with information about each step as well as information about each UUT then you would have a bunch of Recordsets that were only half filled with information therefore wasting space on your disk.

You can definitely create a schema that will log everything to one table in one database but it is not really recommended.  Also you would have to create a Recordset that contained every Field available.  So you would have to go to each table in your database and get all the Fields and then create a Recordset with all those Fields.  If you took the TestStand course and have the manuals then in TestStand I Chapter 11 there are examples that show how to change the schema. If you don't have those manuals then the Reference Manual for TestStand talks about Database Logging in Chapter 6.

Regards,

[Roons1159]

I only want the fields that I want.  Not all of them.  On the statements tab, im prety sure the "Command Text" and "The Apply To" fields are preventing me from entering UUT info and Step result info into the same statement.  Both the software manuals and course manuals do not explain how to change that (unless im missing something of course!!)

Message Edited by Roons1159 on 01-23-2007 01:02 PM

[Roons1159]

Looks like this can't be done, however I am mostly likely retrieving my results wrong.  I tried to create a View in SQL to combine the tables, and that is what's taking it so long.  Is there a better method to trend results using the existing tables that TestStand creates in MySQL or maybe use a different program like DIADEM (note that i have thousands and thousands of records, probably like everyone else).   Any help on this is greatly appreciated.  Thanks.