Difference between revisions of "Database"
Jump to navigation
Jump to search
Line 8: | Line 8: | ||
== needed space == | == needed space == | ||
+ | * 1 mio regify transactions need about 220 MB storage capacity. | ||
+ | * 1000 registered users need about 0,8 MB storage capacity. | ||
+ | |||
+ | As of theese small values, a capacity of 20GB will fit for about | ||
+ | |||
+ | * 90 mio transactions | ||
+ | * 600'000 users | ||
== amount of selects, inserts and updates == | == amount of selects, inserts and updates == |
Revision as of 15:16, 30 December 2009
Contents
supported database systems
The default database for a regify-provider system is MySQL in version 5.1 or greater. Alternatively, you can use IBM-DB2 database to run the regify-provider.
database structure
The regify provider database consists of 14 tables, 30 indices. There are no stored procedures or views involved.
needed space
- 1 mio regify transactions need about 220 MB storage capacity.
- 1000 registered users need about 0,8 MB storage capacity.
As of theese small values, a capacity of 20GB will fit for about
- 90 mio transactions
- 600'000 users