Pepek,
> > The normal cause of wild variations in the performance of queries is > garbage > > collection... > > Garbage collection doesn't seem to play any significant part. I even > deleted the whole backup table, performed the backup/restore cycle, and > still got long times. What *did* help was limiting the SELECT from > sourcetable to "significant records", some 6000 of them (a reduction of > two orders of magnitude). But it still seems strange that Firebird would > choke on INSERTs, even in what I perceive to be the ideal condictions to > the server. > OK, then we'll need to look for less common problems. When the query is slow, are you seeing lots of page faults? Process size growth? What is the rate of reads/writes/marks/fetches? Do you have any guess as to where the time is going? Good luck, Ann [Non-text portions of this message have been removed]
