This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
admin:basics:environments:create [2011/04/13 03:27] doc |
admin:basics:environments:create [2016/06/28 22:38] (current) |
||
|---|---|---|---|
| Line 19: | Line 19: | ||
| There are two methods to create Omnidex Environment Files. They can be created interactively using the [[programs:odxadmin:home|Omnidex Administrator]], or they can be created using SQL statements such as [[dev:sql:statements:create_environment:home|CREATE ENVIRONMENT]], [[dev:sql:statements:create_database:home|CREATE DATABASE]], [[dev:sql:statements:create_table:home|CREATE TABLE]] and [[dev:sql:statements:create_index:home|CREATE INDEX]]. Once created, a simple Omnidex Environment File will look like this: | There are two methods to create Omnidex Environment Files. They can be created interactively using the [[programs:odxadmin:home|Omnidex Administrator]], or they can be created using SQL statements such as [[dev:sql:statements:create_environment:home|CREATE ENVIRONMENT]], [[dev:sql:statements:create_database:home|CREATE DATABASE]], [[dev:sql:statements:create_table:home|CREATE TABLE]] and [[dev:sql:statements:create_index:home|CREATE INDEX]]. Once created, a simple Omnidex Environment File will look like this: | ||
| - | <code sql> | + | <code> |
| > create environment | > create environment | ||
| >> in "simple.xml" | >> in "simple.xml" | ||
| Line 69: | Line 69: | ||
| The easiest way to add Omnidex Indexing is to add indexing information beside each column. This will not work in all situations, such as when multi-column indexes are being created; however, it will work in many simpler installations. More complex installations will require the more complex features described in [[dev:sql:statements:create_table:home|CREATE TABLE]] and [[dev:sql:statements:create_index:home|CREATE INDEX]]. The example below shows the basic addition of Omnidex indexing to the same database. | The easiest way to add Omnidex Indexing is to add indexing information beside each column. This will not work in all situations, such as when multi-column indexes are being created; however, it will work in many simpler installations. More complex installations will require the more complex features described in [[dev:sql:statements:create_table:home|CREATE TABLE]] and [[dev:sql:statements:create_index:home|CREATE INDEX]]. The example below shows the basic addition of Omnidex indexing to the same database. | ||
| - | <code sql> | + | <code> |
| > create environment | > create environment | ||
| >> in "simple.xml" | >> in "simple.xml" | ||
| Line 124: | Line 124: | ||
| > | > | ||
| > update indexes | > update indexes | ||
| - | Updated indexes for HOUSEHOLDS | + | Database |
| - | Updated indexes for INDIVIDUALS | + | Table Rows CPU Elapsed |
| - | Omnidex indexes updated for environment USER_ENVIRONMENT | + | ---------------------------------------------------------------------------- |
| + | SIMPLE | ||
| + | HOUSEHOLDS 1,909 0:00 0:00 | ||
| + | INDIVIDUALS 5,000 0:00 0:00 | ||
| + | ---------------------------------------------------------------------------- | ||
| + | Total 0:00 0:03 | ||
| + | |||
| + | Omnidex indexes updated | ||
| + | > | ||
| </code> | </code> | ||