At 08:02 PM 25/04/2007, you wrote:

>Hello helen,
>
>thanks for the fast reply. The application is running on a machine and
>stores production data and statistics. I've had this problem one year
>ago and thought I have solved it by updating only every minute and
>reading the whole table with a "select count(*) ..." after 10000
>updates. I'm just looking if a collegue disabled this update-strategy,
>but if not I have no more ideas how to solve this problem.

Now it is even less clear.

In your first posting, you said "writing every second the same record
in a table with many colums. Each update is commited." That implies
the table has only one record.

What's the real situation?

./heLen

>Michel
>
>--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@...> wrote:
> >
> > This seems like a terrible bottleneck. What is the purpose? What
> > prompts an update?
> >
> > ./heLen
> >
>
>
>
>
>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>Visit http://www.firebirdsql.org and click the Resources item
>on the main (top) menu. Try Knowledgebase and FAQ links !
>
>Also search the knowledgebases at http://www.ibphoenix.com
>
>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>Yahoo! Groups Links
>
>
>