At 20:47 20.08.2002 +1000, you wrote:

>I want to write a small console application (or GUI) just for more playing
>purposes.
>
>I want to write 100,000 records into a database - speed test type
>application.
>
>1. Is this best done with a TIB_Query ?

No, TIB_DSQL.

>2. Do I create all the records in one long loop ?

If you want to - just avoid using ParamByName, and if you have anything
visible on screen remember to call BeginBusy before your loop.

>3. Do I have to commit every N records to gain performance ?

If you want, you may commit every 10000 or 20000 or something. You could
end up with a four digit number of inserts per second - for simplicity say
4000 per second, that should be approximately 25 seconds to insert your
100000 records. Try it once with all indexes disabled and once with them
all enabled. I think you should observe a difference!

>There's no practical purpose for this exercise apart from my own personal
>desire to understand as much about SQL databases and the implementation of
>IBO in various situations.

How nice it must be to have that much spare time! Mind you, it is a
sensible way to do things.

Set