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 ?

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

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

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.

TIA.


Malcolm Smith
MJ Freelancing
http://www.mjfreelancing.com
C++Builder Software Protection