hi,

may I know the amount of daily transaction (number of insert/update
to the database)? The performance of insert/update is not consistent
in our system..whereby we have about 500,000-600,000 update
transaction a day. insert transaction is performed after update (by
trigger) which also have the same amount. I am trying to improve the
application and database performance.


rgds, chooi ting


--- In firebird-support@yahoogroups.com, "C Fraser"
<Colin.Fraser@h...> wrote:

> Currently running a 6.5GB DB... No problems reported...
>
> Colin
>
> -----Original Message-----
> From: Bogdan Mugerli [mailto:mugerlibogdan@e...]
> Sent: Monday, 10 November 2003 9:32 p.m.
> To: firebird-support@yahoogroups.com
> Subject: [firebird-support] Max file size
>
>
> Hi
>
> We have a large datawarehouse database Firebird 1.03 running on WIN

2000

> SERVER. (NTFS) It is beeing filled every night from data of an old

Cobol

> application. It ran smooth for cca 5 month, then we noticed the
> differences between Cobol data and data in our database.
>
> Database is beeing updated thru triggers in the following way:

there a

> two tables - first collects all data from Cobol database ( date

from -

> date to) the second is dimension table which is updated by triggers

of

> the first table. All is done in single transaction
>
> The problems began, so it seems, when we crossed the 4G limit.
>
> Is it possible that crossing 4G limit is cousing the

inconsistencies.

>
> ( we have 2 other installations with smaller databases that are

running

> with no problems)
>
> Regards
> Bogdan Mugerli
>
>
>
> To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/
>
>
>
>

######################################################################

> Attention:
> The information in this email and in any attachments is

confidential.

> If you are not the intended recipient then please do not

distribute,

> copy or use this information. Please notify us immediately by

return

> email and then delete the message from your computer.
> Any views or opinions presented are solely those of the author.
>

######################################################################