Subject | Re: [firebird-support] slow query at first execution |
---|---|
Author | Helen Borrie |
Post date | 2004-04-28T11:17:02Z |
At 01:12 PM 28/04/2004 +0200, you wrote:
/hb
>no. it's more elaborated.A UNIQUE index?
>the row is inserted.
>then, on demand, is retrieved using an alternate key (the primary key is
>not known by who make the request) to perform an update.
>in normal conditions this happens some seconds after the insert.
>sometimes, it happens some days later.
>i have an index on the alternate key (the key is made up by 2 fields, a
>varchar and an integer).
/hb