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/03/15 19:51] 127.0.0.1 external edit |
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 27: | Line 27: | ||
> | > | ||
> create database "SIMPLE" | > create database "SIMPLE" | ||
- | >> type FLATFILE | + | >> type FILE |
>> index_directory "idx" | >> index_directory "idx" | ||
>> 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 77: | Line 77: | ||
> | > | ||
> create database "SIMPLE" | > create database "SIMPLE" | ||
- | >> type FLATFILE | + | >> type FILE |
>> index_directory "idx" | >> index_directory "idx" | ||
>> 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> | ||