At 30/10/2002 10:55 AM, you wrote:

>Good point! The query prepare can take lot of time.
>Do you have any idea about how to do the same thing via script? Suppose that
>you do not have IBO or another set of components and want to do this with
>isql.... I wonder if it is possible...

You can use IB_SQL which is freeware and is found on IBO website. Also,
the ISQL command-line tool that comes with Firebird seems to have script
support, I've just checked the parameters and the commands found in it, but
I never used the script feature. I know that using a direct API, and maybe
ISQL, to Firebird you "PROBABLY COULD" average over 300,000 records per
minute, but that depends on having the indexes on or off and how big of a
record that you are inserting. But, remember to do a commit after a
certain number of records defined by you, and you could probably test which
one is optimum for your test. Someone, already did this kind of test
before using IBO's direct API method found in TIB_Connection component,
this by-passes the IBO parsing code and sends the DML directly to gds32.dll
API.


Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.accramed.ca)