Difference between revisions of "Database"

From regify WIKI
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 16:16, 30 December 2009

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

amount of selects, inserts and updates