| Subject | Re: AW: AW: [firebird-support] Firebird in automation |
|---|---|
| Author | Adomas Urbanavicius |
| Post date | 2004-12-01T14:53:47Z |
Alexander Gräf wrote:
threads to write 200 records each, and lets make writes and comits every
2secs, that would be 4000 recs, meantime, data would be only 2000recs,
what means, that eveything will be ok, que every 2 secs will become empty.
Adomas
>Ok then (About forced wrties - I agree absolutely.), lets make 20
>
>>-----Ursprüngliche Nachricht-----
>>Von: Adomas Urbanavicius [mailto:adomas@...]
>>Gesendet: Mittwoch, 1. Dezember 2004 15:36
>>An: firebird-support@yahoogroups.com
>>Betreff: Re: AW: [firebird-support] Firebird in automation
>>
>>
>>Well,
>>
>>It is interesting issue : if there are 20 connections, all
>>are writing 50 records/sec, it would be much data safer than
>>1000 records/sec with single connection, wouldnt it ?
>>
>>
>>
>>
>
>No, because if all runs quite symmetrical, for each connection it would take exactly one second to write the 50 records. If the server crashes, the transaction of each connection is rolled back:
>
>
>
threads to write 200 records each, and lets make writes and comits every
2secs, that would be 4000 recs, meantime, data would be only 2000recs,
what means, that eveything will be ok, que every 2 secs will become empty.
Adomas