This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
admin:admin:applications:testing [2011/02/15 00:36] deb |
admin:admin:applications:testing [2016/06/28 22:38] (current) |
||
|---|---|---|---|
| Line 8: | Line 8: | ||
| ===== 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]] |
| ---- | ---- | ||
| Line 20: | Line 20: | ||
| - [[#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 28: | 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. | ||