This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
|
admin:admin:applications:testing [2011/01/10 17:08] 127.0.0.1 external edit |
admin:admin:applications:testing [2016/06/28 22:38] (current) |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| + | ~~NOTOC~~ | ||
| + | |||
| {{page>:top_add&nofooter&noeditbtn}} | {{page>:top_add&nofooter&noeditbtn}} | ||
| - | ====== Omnidex Administration ====== | + | |
| + | ====== Administration: Administration Basics ====== | ||
| ===== Building Omnidex Applications ===== | ===== Building Omnidex Applications ===== | ||
| - | [[admin:admin:applications:design|Design]] -> [[admin:admin:applications:prototype|Prototype]] -> [[admin:admin:applications:development|Development]] -> **[[admin:admin:applications:testing|Testing]]** -> [[admin:admin:applications:staging|Staging]] -> [[admin:admin:applications:production|Production]] -> [[admin:admin:applications:optimization|Optimization]] | + | [[admin:admin:applications:design|Design]] | [[admin:admin:applications:prototype|Prototype]] | [[admin:admin:applications:development|Development]] | **[[admin:admin:applications:testing|Testing]]** | [[admin:admin:applications:staging|Staging]] | [[admin:admin:applications:production|Production]] | [[admin:admin:applications:optimization|Optimization]] |
| ---- | ---- | ||
| - | |||
| ==== Testing ==== | ==== Testing ==== | ||
| - | It is important to test Omnidex application, just as it is important to test any application. Testing will help validate the indexing strategy and insure performance. Testing will also insure that there are no mistakes with either the application or SQL language interfaces. | + | It is important to test your Omnidex application, just as it is important to test any application. Testing will help validate the indexing strategy and insure performance. Testing will also insure that there are no mistakes with either the application or SQL language interfaces. |
| - | Testing strategies vary greatly within business. The following six recommendations can be incorporated into the testing strategy for the application to insure that Omnidex is properly integrated and performing well. | + | Testing strategies vary greatly within organizations. The following six recommendations can be incorporated into the testing strategy for the application to insure that Omnidex is properly integrated and performing well. |
| - [[#General_Recommendations|General Recommendations]] | - [[#General_Recommendations|General Recommendations]] | ||
| - [[#Testing_Query_Syntax|Testing Query Syntax]] | - [[#Testing_Query_Syntax|Testing Query Syntax]] | ||
| - [[#Testing_Query_Optimization|Testing Query Optimization]] | - [[#Testing_Query_Optimization|Testing Query Optimization]] | ||
| - | - [[#Testing_Individual_Query_Performance|Testing Individual Query Performance]] | + | - [[#Testing_Query_Performance|Testing Query Performance]] |
| - | - [[#Testing_Concurrent_Query_Performance|Testing Concurrent Query Performance]] | + | - [[#Testing_ODBC_or_JDBC_Performance|Testing ODBC or JDBC Performance]] |
| - | - [[#Testing_Network_Performance|Testing Network Performance]] | + | |
| | | ||
| === General Recommendations === | === General Recommendations === | ||
| Line 26: | Line 27: | ||
| The testing of Omnidex applications usually focuses on query syntax, query results and query performance. We recommend that these tests be performed first on the Omnidex server, then on the Omnidex client, and finally in the application itself. This approach to testing makes it easier to isolate the Omnidex aspects of an application from the other layers of the application. | The testing of Omnidex applications usually focuses on query syntax, query results and query performance. We recommend that these tests be performed first on the Omnidex server, then on the Omnidex client, and finally in the application itself. This approach to testing makes it easier to isolate the Omnidex aspects of an application from the other layers of the application. | ||
| - | The OdxSQL program is a valuable testing tool. OdxSQL is a console application that allows SQL statements to be executed and results to be display. OdxSQL also supports statements that create, administrate and maintain Omnidex databases. Where the Omnidex Administrator program is a Windows-based, interactive application for administrating Omnidex databases, OdxSQL serves the same role as a console application. OdxSQL also can be used within scripts, allowing for more automated testing. | + | The OdxSQL program is a valuable testing tool. OdxSQL is a console application that allows SQL statements to be executed and results to be displayed. OdxSQL also supports statements that create, administrate and maintain Omnidex databases. Where the Omnidex Administrator program is a Windows-based, interactive application for administrating Omnidex databases, OdxSQL serves the same role as a console application. OdxSQL also can be used within scripts, allowing for more automated testing. |
| OdxSQL makes it easy to test queries and other statements, first on the server and then through an ODBC or JDBC interface. OdxSQL can process a text file containing SQL statements, allowing a well-crafted suite of SQL statements to verify results and benchmark performance. OdxSQL can also be run as a client tool, allowing these same SQL statements to be run using Omnidex's ODBC or JDBC interface. | OdxSQL makes it easy to test queries and other statements, first on the server and then through an ODBC or JDBC interface. OdxSQL can process a text file containing SQL statements, allowing a well-crafted suite of SQL statements to verify results and benchmark performance. OdxSQL can also be run as a client tool, allowing these same SQL statements to be run using Omnidex's ODBC or JDBC interface. | ||
| Line 38: | Line 39: | ||
| Query optimization is tested by configuring OdxSQL to automatically display query plans as SQL statements are run. The query plans will show the exact optimization used when processing the query. | Query optimization is tested by configuring OdxSQL to automatically display query plans as SQL statements are run. The query plans will show the exact optimization used when processing the query. | ||
| - | Query optimization can also be tested by configuring OdxSQL to issue an error if queries are not properly optimized or if queries take too long. A wide variety of optimization settings can be used to require Omnidex indexes to be used, and timeouts can be used to issue an error if a query exceeds a set time limit. | + | Query optimization can also be tested by configuring OdxSQL to issue an error if queries are not properly optimized or if queries take too long. A wide variety of optimization settings can be used to require Omnidex indexing to be used, and timeouts can be used to issue an error if a query exceeds a set time limit. |
| === Testing Query Performance === | === Testing Query Performance === | ||
| Line 48: | Line 49: | ||
| ODBC and JDBC performance can be tested by running OdxSQL in ODBC or JDBC mode. This causes OdxSQL to act as a client, processing each statement through the ODBC or JDBC interface to the server. Query performance can then be logged and analyzed as was done on the server. | ODBC and JDBC performance can be tested by running OdxSQL in ODBC or JDBC mode. This causes OdxSQL to act as a client, processing each statement through the ODBC or JDBC interface to the server. Query performance can then be logged and analyzed as was done on the server. | ||
| - | The [[programs:odxsql:home|OdxSQL Reference Manual]] section of the documentation describes the general use of OdxSQL. | + | The [[programs:odxsql:home|OdxSQL documentation]] describes the general use of OdxSQL. |
| - | ====== ====== | + | ===== ===== |
| - | \\ | + | |
| - | ---- | + | |
| - | \\ | + | |
| - | + | ||
| - | The next stage in building Omnidex applications is [[admin:admin:applications:staging|Staging]]. | + | |
| **[[admin:admin:applications:development|Prev]]** | **[[admin:admin:applications:staging|Next]]** | **[[admin:admin:applications:development|Prev]]** | **[[admin:admin:applications:staging|Next]]** | ||
| + | ====== Additional Resources ====== | ||
| + | |||
| + | See also: | ||
| + | |||
| + | {{page>:admin:admin:see_also&nofooter&noeditbtn}} | ||
| {{page>:bottom_add&nofooter&noeditbtn}} | {{page>:bottom_add&nofooter&noeditbtn}} | ||