Subject Re: foreign keys ans slow insert
Author mk_delphi
why not migrate FK to a couple of triggers?
in the beforeinsert of the main table you can
check for Foreign record, in the beforedelete of
foreign table you can check if the key is in the
main table, but note this is subject to transactions
status. I think this is better then put checks inside


--- In, German Pablo Gentile
<listas.ggentile@c...> wrote:
> i will rewrite my question, as i see the orginial post was not
> Sorry by my english.
> I have a table with a moderated grow rate (100000 records at
> Actually have only 100000 records.
> That table have ten ids to ten tables, all have foreign keys. the
> inserted in the main table related to the other tables are not
> The performence is terrible,it takes 3 seconds to insert a record.
> need to know what can i be wrong. I try all: async writes, sweep =
0 ,
> backup restoring, running server in w2k, linux,nothing works. Im
> FB 1.5.1 and FIB+.
> Any help welcomed.
> German.