Issue #49 - Performance Test - Bind Variables

[spcelestials]

@robe070 - new PR created.

[robe070]

Please acknowledge each comment above which you have dealt with when you push more commits to the PR.

[spcelestials]

remove the intermediary fields for mysql

@robe070 - removed the intermediary fields for mysql as well.

[spcelestials]

remove the intermediary fields for mysql

@robe070 - removed the intermediary fields for mysql as well.

[robe070]

Oracle connection is fine. e.g.

sqlplus <UID>/<PWD>@ora19cdb

[robe070]

When using the ODBCQuery Tool, choose the ORACLE ODBC Connection:

[robe070]

When using SQLPLUS, these commands help to format the output better which defaults to a width of 80 characters:

SQL> SET LINESIZE 300
SQL> SET TRIMOUT ON
SQL> SET TRIMSPOOL ON

[spcelestials]

When using SQLPLUS, these commands help to format the output better which defaults to a width of 80 characters:

SQL> SET LINESIZE 300
SQL> SET TRIMOUT ON
SQL> SET TRIMSPOOL ON

@robe070 - sure, will work it and update you.

[spcelestials]

When using SQLPLUS, these commands help to format the output better which defaults to a width of 80 characters:

SQL> SET LINESIZE 300
SQL> SET TRIMOUT ON
SQL> SET TRIMSPOOL ON

@robe070 - sure, will work it and update you.

@robe070 - Oracle script and PS script updated

[spcelestials]

milliseconds text removed in the mysql output

@robe070 - Updated the all SQL and POSH scripts based on the database type and output text.

[robe070]

@spcelestials Please attach a copy of your latest PerformanceMetricsLog.txt. @ashtkumar2023 can then use this as her input file. As well as I can check its format.

Also change all naming from Statistics to Metrics

[spcelestials]

@spcelestials Please attach a copy of your latest PerformanceMetricsLog.txt. @ashtkumar2023 can then use this as her input file. As well as I can check its format.

Also change all naming from Statistics to Metrics

PerformanceMetricsLog.txt

[spcelestials]

@spcelestials Please attach a copy of your latest PerformanceMetricsLog.txt. @ashtkumar2023 can then use this as her input file. As well as I can check its format. Also change all naming from Statistics to Metrics

PerformanceMetricsLog.txt

@robe070 - Renamed from Statistics to Metrics in SQL script and PS files.

[ashtkumar2023]

@robe070 , The Log table is getting generated this way . Can you please review this file ? PerformanceMetricsLogTable.txt It is appearing as a comma separated text file as of now similar to the log file.

[robe070]

@robe070 , The Log table is getting generated this way . Can you please review this file ? PerformanceMetricsLogTable.txt It is appearing as a comma separated text file as of now similar to the log file.

Well at least you have output a file. Now you must reformat it as per the Teams discussion. You need to search through the list for say, MSSQLS entries to construct the first row of the new list. Add that entry to the list. Then search through the entire list for MYSQL entries to construct the 2nd row of the new list. Etc.:

Tabular Output in c:\program files (x86)\lansa\PerformanceMetricsTable.txt DBTYPE, LANSA, Literal, Bind, MSSQLS, 85, 80, 24 MYSQL, 37, 36, 23 etc

[ashtkumar2023]

DBTYPE, LANSA, Literal, Bind,

DBTYPE, LANSA, Literal, Bind, --I will be adding this as a header to the formatted list.

[ashtkumar2023]

@robe070 , The Log table is getting generated this way . Can you please review this file ? PerformanceMetricsLogTable.txt It is appearing as a comma separated text file as of now similar to the log file.

Well at least you have output a file. Now you must reformat it as per the Teams discussion. You need to search through the list for say, MSSQLS entries to construct the first row of the new list. Add that entry to the list. Then search through the entire list for MYSQL entries to construct the 2nd row of the new list. Etc.:

Tabular Output in c:\program files (x86)\lansa\PerformanceMetricsTable.txt DBTYPE, LANSA, Literal, Bind, MSSQLS, 85, 80, 24 MYSQL, 37, 36, 23 etc

I have implemented this without "LANSA" column

[robe070]

Please add the tables to the User List.

[robe070]

Please produce the LANSA timings. Use the Now() intrinisic on datetime fields because they have millisecond accuracy.

Define Field(#Start) Type(*DEC) Length(10) Decimals(3)
Define Field(#Finish) Type(*DEC) Length(10) Decimals(3)
Define Field(#Duration) Type(*DEC) Length(7) Decimals(0)

#Start := #STD_DTIMX.Now().AsSeconds

<Select statement >

#Finish := #STD_DTIMX.Now().AsSeconds
#Duration := (#Finish - #Start) * 1000 /* Change to milliseconds */

[ashtkumar2023]

Please produce the LANSA timings. Use the Now() intrinisic on datetime fields because they have millisecond accuracy.

Define Field(#Start) Type(*DEC) Length(10) Decimals(3)
Define Field(#Finish) Type(*DEC) Length(10) Decimals(3)
Define Field(#Duration) Type(*DEC) Length(7) Decimals(0)

#Start := #STD_DTIMX.Now().AsSeconds

<Select statement >

#Finish := #STD_DTIMX.Now().AsSeconds
#Duration := (#Finish - #Start) * 1000 /* Change to milliseconds */

OK.I will work on the above.

[robe070]

@ashtkumar2023 I've seen this message arrive by email, but I can't see it in the conversation. Maybe you've resolved it?

@robe070 , In the select statement, I understand that VI0049C needs to do a SELECT on the table. Can you please clarify on which table the select has to be executed?

The same table and the same select as all the other SQL script tests.

[ashtkumar2023]

@ashtkumar2023 I've seen this message arrive by email, but I can't see it in the conversation. Maybe you've resolved it?

@robe070 , In the select statement, I understand that VI0049C needs to do a SELECT on the table. Can you please clarify on which table the select has to be executed?

The same table and the same select as all the other SQL script tests.

@robe070 , Sorry . I am resolving it using the same table for all databases. Thank you.

[ashtkumar2023]

I generated a Log file including 'LANSA' column with the above commit. PFA. PerformanceMetricsLog.txt I will generate the Logtable file including 'LANSA' in my next commit and share it.