Subject AW: [firebird-support] Firebird in automation
Author Alexander Gräf
> -----Ursprüngliche Nachricht-----
> Von: Michele Cannella [mailto:michele.cannella@...]
> Gesendet: Mittwoch, 1. Dezember 2004 14:09
> An: firebird-support@yahoogroups.com
> Betreff: [firebird-support] Firebird in automation
>
>
> Someone could suggest some 'trick' to keep using firebird for
> this job ?


You could try to deactivate FORCED WRITES, so that the records can be cached by the file system. However, this introduces the risk of loosing data and even damage the database file, especially on Windows. Also, if there are any indices associated with the table you are data filling in, you can deactive those, which also gives a little performance gain:

ALTER INDEX IDX_Table_Index INACTIVE;

Hope that helps, Alex