| Subject | Re: [firebird-support] slow query at first execution |
|---|---|
| Author | Marco Parmeggiani |
| Post date | 2004-04-28T11:12:39Z |
In data Wed, 28 Apr 2004 20:13:31 +1000, hai scritto:
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).
ciao
>no. it's more elaborated.
> What you peraps should do is get the PJ first (direct from the generator)-
> before you do the insert, then you don't have to retrieve it from the table
> later - it save a lot of time and resource load.
> Alan
>
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).
ciao