|Subject||Re: [firebird-support] First insert in large table takes extreme time|
>> Does the 'INSERT INTO' take equally long time if you use a unique (or atPerhaps some kind of "refresh all" fetching all records, or doing a
>> least selective) value in all the indexed fields which have over 100
>> million max duplicates?
> Well, I tried to insert a record with null in all nullable columns,
> which should "hit" the long duplicate chains of all indexes, so should
> be slow, right? It wasn't. In FlameRobin, after having closed all,
> including the FB service and then restarted FB service, FlameRobin,
> connect from FR, insert as the first thing. Cache should be empty at
> this point.
> So, I guess I'll have to check exactly what statement from my
> application causes this long execution time. I'm unable to reproduce it
> from FlameRobin, it seems.
SELECT COUNT(*) or reposition the indicator of a data-aware grid etc.
behind the scene.
If you are using Firebird 2.5, then use the Trace API to find out what
your application is exactly doing.
Download LogManager Series, FB TraceManager today!
Continuous Database Monitoring Solutions supporting
Firebird, InterBase, Advantage Database, MS SQL Server