Subject RE: [ib-support] Child Tables Problem Revisited
Author Bill Morrison
Hi Doug,

I've modified it so it is doing the transactions the way you described,
and I still have the same problem with the database size creeping up. Note
that it does cause a small performance issue, but once I resolve this other
problem I can restore it and see if it's a culprit.

If I watch the allocated pages for the database, it'll increase by 1 or so
every 500 records. Only the deletions and additions are occuring.



-----Original Message-----
From: Doug Chamberlin [mailto:DChamberlin@...]
Sent: Wednesday, October 31, 2001 7:43 AM
Subject: RE: [ib-support] Child Tables Problem Revisited

At 10/31/2001 10:25 AM (Wednesday), Bill Morrison wrote:
>I am using the tiCommitted for the isolation level, and explicity commiting
>after every 15 writes, or 15 seconds (the system averages 6 written records
>/ second). Commit-Retaining is not used. In addition, I have verified that
>the OAT is advancing normally. I cannot imagine how I could be any more
>specific with my transactions.

Sounds to me that you should be committing every time you do the write
logic. For example,
1) Start Trans
2) Check for needing to delete existing record and delete it
3) Write new record
4) Commit

If you did it this way you would be sure the other process would see every
written record immediately after it was committed.

I'm curious as to why you commit every 15 writes or 15 seconds. Have you
tried something like I've suggested above and actually observed a
performance problem with it? That's the only reason I can think of not
committing every write.

To unsubscribe from this group, send an email to:

Your use of Yahoo! Groups is subject to