Database

From regify WIKI
Revision as of 15:16, 30 December 2009 by Regify (talk | contribs) (→‎needed space)
Jump to navigation Jump to search

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