With a large number of existing views, the compilation of new views (or drop existing) is very slow and the time increases as the number of views increases.
Time for create 1 view:
- on empty database: 0.2s
- 50 view already exist: 1s
- 100 view already exist: 1.7s
- 200 view already exist: 3.3s
The CPU load (1 core) is 100%, and the time is almost independent of the computer configuration, i.e. that on the server with 2 Xeon processors, 64Gb of memory and hardware RAID, that on the usual desktop.
When creating real databases ~ 1000-1500 view, creating 1 view gradually slows down ~ from 30 sec. up to 1 min.
On real databases ~1000 view, creating 1 view takes ~ from 30 seconds up to 1 min.
Approximate number of records in real databases:
RDB$DEPENDENCIES ~ 1 000 000
RDB$RELATION_FIELDS ~ 300 000
RDB$RELATIONS ~ 3 500