IBExpertDemoDB

Use the IBExpertDemoDB for benchmark testing. The UDFs and SQLs necessary to generate the demo database can be found in the IBExpert Developer Studio's /IBExpertDemoDB directory. This documentation lists the simple steps needed to generate a demo database to the size of your choice.

The IBExpert Benchmarks article illustrates in detail how to utilize this valuable function as a sample web shop.

In the subdirectory, \IBExpertDemoDB, you will find a script, db1_30.sql, which you an use to create a Firebird 3.0 database. Among other things this includes a Soundex function as a stored procedure, as a stored function and as a package. By these means you can create your own functions in Firebird 3.0 or using your own UDF, and use them in SQL as if they were an internal function.

Furthermore there is a basic implementation for a materialized view alternative in this script, which can also be used with older Firebird versions.

By combining a view with a static table it is possible to avoid calculating complex result sets each and every time, and only recalculate them following expiry of specified time intervals.


Any comments? Send an email to register@ibexpert.biz

 COPYRIGHT © 2002-2022 HK-Software, IBExpert Ltd. All rights reserved.
 
 All IBExpert brand and product names are trademarks or registered trademarks 
 of IBExpert Ltd in Malta and other countries. InterBase, Delphi, CodeGear, 
 C++Builder and JBuilder are trademarks or registered trademarks of Embarcadero 
 Technologies Inc. in the United States and other countries. Firebird is a 
 registered trademark of the FirebirdSQL Foundation. Sun, Java, JavaScript and 
 Solaris are trademarks or registered trademarks of Sun Microsystems, Inc. or 
 its subsidiaries in the United States and other countries. UNIX is a registered 
 trademark in the United States and other countries, exclusively licensed 
 through “The Open Group”. Oracle is a registered trademark of Oracle Corporation 
 in the United States and other countries. All Microsoft brand and product names 
 are trademarks or registered trademarks of Microsoft Corporation in the United 
 States and other countries. AS/400, DB2, IBM, Informix and iSeries are trademarks 
 or registered trademarks of IBM Corporation in the United States and other countries. 
 Linux is a registered trademark of Linux Torvalds. All other product names mentioned 
 herein and throughout the entire web site are trademarks of their respective owners.