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.