IBExpert Demo Databases:


In this Installer, you can find some Demo Databases Scripts.

It is not allowed to publish any content of these scripts anywhere
without a permission of HK-Software. For asking for such a permission,
please send an email to info@h-k.de with a description, where 
you want to use it.

Usage:

Open IBExpert, use menu tools-Script Executive and press 
Ctrl+L to load the File. After Loading, Press F9 to execute 
the script.

Donīt forget to copy the UDF Libraries into the UDF Subdirectory.


db1.sql: 

A Database to create a very large Testdatabase with Demo data. 
Execute the Script in IBExpert and start Procedure INITALL
with a parameter how much data should be created. We recommend 
to start with the value 100000. This will create a database
in about 19 minutes (time on a 1,7 Ghz Dell 9300 Laptop, 100 GB
Disc, 2 GB RAM). Size was about 217 MB.

If you have other Configurations where you want to test the same 
database, please send the result with a simple hardware description 
to hklemt@ibexpert.biz. We will publish the results on
www.ibexpert.com to give you some help for getting faster 
hardware from your company :-)


This Demodatabase should work on Interbase and Firebird, even it 
was only tested on firebird 1.5.



db2.sql:

A database that implements a simple Transaction Log based on 
Triggers and Stored Procedures. To activate the Log, execute 
the Procedure INITLOG. After it was activated, just open table 
adr and do your insert, update or delete commands. The SQL 
Statements are stored in a table called IBE$REPL. To see
them, you can set option "Show System Tables" in 
http://www.ibexpert.info/documentation/46455.html

To add more tables, first execute procedure Droplog. 

Now you can add your own table (Blob columns are curreently 
not supported) and execute procedure INITLOG again. 

Now you will see also the SQL statements for the operations in 
new table in IBE$REPL. 

This Demodatabase works only on Firebird >=1.5






Stats for db1.sql executing initall(100000)

Query
------------------------------------------------


Plan
------------------------------------------------


Adapted Plan
------------------------------------------------


Query Time
------------------------------------------------
Prepare       : 0,00 ms
Execute       : 1.144.578,00 ms
Avg fetch time: 0,00 ms

Memory
------------------------------------------------
Current: 1.622.552
Max    : 3.900.800
Buffers: 2.048

Operations
------------------------------------------------
Read   : 174.920
Writes : 102.078
Fetches: 79.732.384


Enchanced Info:
+--------------------------+-----------+-----------+-------------+---------+---------+---------+
|        Table Name        |  Records  |  Indexed  | Non-Indexed | Updates | Deletes | Inserts |
|                          |   Total   |   reads   |    reads    |         |         |         |
+--------------------------+-----------+-----------+-------------+---------+---------+---------+
|                  CUSTOMER|         0 |         0 |           0 |       0 |       0 |  100000 |
|          CUSTOMER_HISTORY|         0 |         0 |           0 |       0 |       0 |  599734 |
|                 INVENTORY|         0 |   1199468 |           0 |  599734 |       0 |  100000 |
|                 ORDERLINE|         0 |   1398669 |           0 |       0 |       0 |  599734 |
|                    ORDERS|         0 |    799734 |           0 |  200000 |       0 |  200000 |
|                   PRODUCT|         0 |    599734 |           0 |       0 |       0 |  100000 |
|                   TMP_ADR|         0 |    100000 |           0 |       0 |       0 |       0 |
|                  TMP_CITY|         0 |    100000 |           0 |       0 |       0 |       0 |
|                    TMP_FN|         0 |    100000 |           0 |       0 |       0 |       0 |
|                   TMP_FN2|         0 |    200000 |           0 |       0 |       0 |       0 |
|                    TMP_LN|         0 |    100000 |           0 |       0 |       0 |       0 |
|                   TMP_LN2|         0 |    200000 |           0 |       0 |       0 |       0 |
|                 TMP_STATE|         0 |    100000 |           0 |       0 |       0 |       0 |
|             TMP_TITLEWORD|         0 |    300000 |           0 |       0 |       0 |       0 |
+--------------------------+-----------+-----------+-------------+---------+---------+---------+
