Author: Holger Klemt

[See remaining text…] 

More examples can be found here
http://www.ibexpert.info/documentation/20297.html

For using the distribution license, no keys are needed. You do
not even need ibexpert full version, but the integrated debugger
will help you to develop working scripts.

The distribution license contains only the file ibescript.exe or
ibescript.dll and the unlimited right to distribute it together
with your software.

—————————————————————–

1. What is IBEScript EXE?

IBEScript.exe can be used to execute any valid IBExpert script in
batchfiles. For example a scheduled import or export job can be
started without the need of any user input.

IBEScript.exe can also be used to encrypt script files, so that
they are unreadable for the user, but executable together with
IBEScript.exe

2. What is IBEScript DLL?

When you want to integrate IBExperts scripts in your own application,
you can use IBEScript.dll. A simple example for Delphi can be found
in IBExperts IBEScriptDll subdirectory. It can also be used from all
other programming languages that can handle DLL calls.

3. What is IBEBLOCK?

It is a set of DDL, DML and other statements that are executed on
the server and on the client side, and which include some specific
constructions applicable only in IBExpert or IBEScript (excluding
the free versions of these products), independent of the database
server version.

With EXECUTE IBEBLOCK you will be able to:

* Work with different connections within the single IBEBLOCK at
the same time.
* Move (copy) data from one database to another.
* Join tables from different databases.
* Compare data from different databases and synchronize them.
* Populate a table with test data using random values or values
from other tables or even from other databases or ODBC Connections.
* … and much more.

The syntax of IBEBLOCK is similar to that of stored procedures but
there are many important extensions. For example:

* You can use EXECUTE STATEMENT with any server, including
InterBase 5.x, 6.x, 7.x.
* You can use one-dimensional arrays (lists) of untyped variables
and access them by index.
* It isn’t necessary to declare variables before using them.
* You can use data sets (temporary memory tables) to store data.
* … and much more.

4. Simple ibeblock example to copy data between two databases incl blobs

execute ibeblock
as
begin
create connection src dbname ‘localhost:c:src.fdb’
password ‘repl’ user ‘REPL’ clientlib ‘fbclient.dll’;

create connection dest dbname ‘localhost:c:dest.fdb’
password ‘repl’ user ‘REPL’ clientlib ‘fbclient.dll’;

use src;
for select id, usr, ts, sql, idx, dat
from ibe$log
into :id, :usr, :ts, :sql, :idx, :dat
do
begin
use dest;
insert into ibe$log(id, usr, ts, sql, idx, dat)
values (:id, :usr, :ts, :sql, :idx, :dat);
end

use dest;
commit;
close connection src;
close connection dest;
end

You can execute single IBEBLOCKs via the SQL Editor. You can debug them
in the SQL Editor too. They are debugged in the same way as stored
procedures and triggers. Also you can include IBEBLOCKs into your
scripts and execute these scripts as usual – using the Script
Executive or IBEScript.exe.

To buy our distribution license products visit our shop at
http://www.hk-software.net/h-k.de/content/doc_138099-11-1-00.php
and open the product group “distribution license”

5. IBExpert Educational Full Version for only 50 Euro (excl. VAT)

For students and teachers at schools or universities, we offer the
free IBExpert Educational Version with the 50MB database limit already
since a long time. A lot of people already told us that they are
very happy with using IBExpert and Firebird in their studies.

If they want to use it for larger databases also, they can now
get the IBExpert 1 License for Educational Purposes Full License
for a special price.

This product is not only available for students and teachers at
commercial schools or universities.

We require the following information for your product registration

* User name
* User e-mail address
* Computer name of the computer, where IBExpert is to be installed.
* Copy of the valid school students identity card
or
Copy of the valid university students identity card
or
Official order from the School/University

We need the copies as scanned email attachments to
register@ibexpert.com or fax to +4970042397378

IF WE DO NOT GET THE INFORMATIONS IN READBLE FORMAT, WE WILL NOT
BE ABLE TO PROCESS THE ORDER.

To buy IBExpert Educational Full Version visit our shop at
http://www.hk-software.net/h-k.de/content/doc_138099-11-1-00.php
and open the product group “software for educational purposes”

The price is 50 Euro. In Germany and Europe we have to charge you
additional 8 Euro VAT. When you want to pay by bank transfer, be
sure that all transfer fees are paid from the customer, otherwise
we can not deliver the product before we receive all the money.
We recommend to use paypal.

The IBExpert Team

Any questions? Ask register@ibexpert.com

The most Expert for InterBase and Firebird — www.ibexpert.com
HK Software – Gerhard Stalling Str 47A – 26135 Oldenburg – Germany
Phone/Fax +49 700 IBEXPERT (42397378) www.h-k.de

« Hide it

[See remaining text…] 

the procedures creates a customer table from the strings in the
helptables, it creates products from other strings, it creates
order header and order lines. based on that some trigger also
write a sales history etc.

all in all you can create a testdatabase as large as you need, because
the procedure called initall gives you the possibilty to fill a
parameter with an integervalue, that defines the size of the final
database. when you use the value 10000, then 10000 customers are
created, 10000 articles and a lot of orders etc. The Testdatabase
is before starting the procedure created with 16k pagesize and the
cache buffers were changed to 50000.

for the test i used a value of 100000 so the final database that is
created has a size of about 200MB.

While executing this procedure with the parameter 100000, it starts
about 5,200,000 Selects, 800,000 Updates and 1,700,000 Inserts, all
in all about 7,700,000 Operations.

now the time when starting this on a dual core AMD Athlon 64 x2 3800+
with 2 GB RAM.

using fb153: 486 Seconds (not bad, about 16,000 Operations per second)

uninstalled fb153, installed fb2 beta 2: 244 Seconds!!!!!!!!

Wow, not that i would say it was slow on fb153, but the results on
fb2b2 are impressive. About 31500 Operations per second.

Congratulations to the developer Team. they made a brilliant job.

Starting with the next IBExpert Version, the Demodatabase will be
available also in the trial version and in the personal edition.

if you would like to test it now on your machine, just Install
IBExpertLive (download details on www.ibexpert.com). I have added
the demodatabase in my session “Holger Klemt – Server Performance –
How to make your application run faster (FBC2005)”, so you can connect
to view this session and press on the left side on “download session
files” to get the installer.

Holger
www.ibexpert.com

p.s.: did i mention the result from ib751? 838 Seconds

« Hide it