Subject | Re: [firebird-support] Re: Increasing memoryusage and decreasing performance |
---|---|
Author | Helen Borrie |
Post date | 2007-04-25T11:23:07Z |
At 09:11 PM 25/04/2007, you wrote:
for each column, like
update atable
set column1 = :avalue
where pk = 99
COMMIT
update atable
set column2 = :bvalue
where pk = 99
COMMIT
update atable
set column3 = :bvalue
where pk = 99
COMMIT
.... and so on...
and you restart this cycle every 60 seconds?
Are there any update triggers on the table?
./heLen
>Hello Helen,Suppose there are 50 columns. Are you executing one update statement
>there are no other clients. The server is running local on the same
>computer as the application. I'm doing no Commitretaining. There is
>more than one update-query executed for different columns of that record.
for each column, like
update atable
set column1 = :avalue
where pk = 99
COMMIT
update atable
set column2 = :bvalue
where pk = 99
COMMIT
update atable
set column3 = :bvalue
where pk = 99
COMMIT
.... and so on...
and you restart this cycle every 60 seconds?
>When the machine is running there are normally only these updatesCan you show the client code that executes?
>running on the DB.
Are there any update triggers on the table?
./heLen