Hi,
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
applications.

Marco

--- In firebird-support@yahoogroups.com, German Pablo Gentile
<listas.ggentile@c...> wrote:

> i will rewrite my question, as i see the orginial post was not

clear.

> Sorry by my english.
>
> I have a table with a moderated grow rate (100000 records at

month).

> Actually have only 100000 records.
> That table have ten ids to ten tables, all have foreign keys. the

ids

> inserted in the main table related to the other tables are not

unique.

>
> The performence is terrible,it takes 3 seconds to insert a record.

I

> 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

using

> FB 1.5.1 and FIB+.
>
> Any help welcomed.
>
> German.