The table which makes up bulk of these inserts has

11 Fields all except 3 are integers and timestamps
3 Fields are varchar(256). Each would have strings approx. 150 chars
long in one of these. The other two string tables are smaller.

There are no special transactional considerations. Each insert
follows the same procedure :

Create a transaction
Insert
Commit transaction
Release transcation handle.

I have a feeling if its the number of transaction objects which I use
(1 for each insert), but I may be wrong.


-Ergsg

--- In ib-support@y..., "Alan McDonald" <alan@m...> wrote:
> How small are these inserts?
> 200,000 per day and the database is only 30 MB?
> something doesn't add up
>
> Alan
> -----Original Message-----
> From: erg_sg [mailto:erg_sg@y...]
> Sent: Wednesday, 23 October 2002 19:02
> To: ib-support@y...
> Subject: [ib-support] Re: Database Crash
>
>
> Paul,
>
> The database size is about 30 MB....
>
> Regards
> --Ergsg
>
>
> --- In ib-support@y..., Paul Reeves <paul@f...> wrote:
> > erg_sg wrote:
> > >
> > > SBSERVER (Server) <Time>
> > > Database: C:\CSC\DATABASE\CSC.GDB
> > > I/O error for file "C:\CSC\DATABASE\CSC.GDB"
> > > Error while trying to read from file
> > > Reached end of file.
> > >
> >
> > This leads me to wonder - how big is the database when the
crash
> occurs?
> >
> >
> > Paul
> > --
> >
> > Paul Reeves
> > http://www.ibphoenix.com
> > Supporting users of Firebird and InterBase
>
>
> Yahoo! Groups Sponsor
> ADVERTISEMENT
>
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@e...
>
>
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service.
>
>
>
> [Non-text portions of this message have been removed]