| Table of Contents |
|---|
...
This chapter describes things to consider when designing a DB or system using ALTIBASE. It is recommended to consider the following items and refer to the design because not only the impact on the design stage but also on the development stage and the operation stage is significant.
...
Comparison | Lazy Method | Eager Method |
|---|---|---|
Performance | 90% performance level of a single server | Performance degradation compared to the Lazy method |
SynchrnoziationSynchronization | This is a structure that checks only the success of transmission of the changed transaction log to another server, so it is a high performance, but synchronization may be delated. | To prevent data inconsistency on another server, performance is rapidly delayed because it is also committed locally on another server, but the synchronization is not delayed. |
...
Altibase replication is a form sending changed log of a transaction occurring on the local server. This means that even if one million statements are changed with one SQL statement, the same is the structure in which a million changed transaction logs are transmitted, not the same for as one SQL statement transmitted to a remote server.
...
In addition to HA, it is necessary to establish a backup policy for data file damage caused by physical disk failure and failure caused by transaction log file corruption. The Altibase backup method provides both full and incremental backup methods using the archive mode.
...
In the case of the numeric type provided by ALTIBASE, a type such as Numeric (9) can be sufficiently expressed as an integer type, but occupies 8 bytes of space. It occupies 4 bytes per record more than integer type. In terms of processing performance, numeric internally incurs the cost of converting back to native type, which is somewhat slower than the integer type.
It is recommended to the followings following when selecting a column type.
Consideration | Description |
Numeric Type | 1.Consider to minimize Consider minimizing the conversion cost of Native ßà Non-Native (Native type [Integer, Double, BigInt] is more advantageous in terms of performance) 2. Double type is selected when the precision of the real type is not required. |
Date Type | If the date-related operation is important, select the Date type. If it is limited to search and comparison operations, select the Char/Varchar type. (Date type is fixed at 8 bytes) |
Join | Consider that the type conversion does not occur if the column is a Join |
...
...