Subject Re: [IBO] Another Self Exercise
Author Svein Erling Tysvaer
At 20:47 20.08.2002 +1000, you wrote:
>I want to write a small console application (or GUI) just for more playing
>I want to write 100,000 records into a database - speed test type
>1. Is this best done with a TIB_Query ?


>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.