Subject Re: [firebird-support] import data from external table (huge file)
Author Martijn Tonies
> > > >Is the file too big to do the import?
> > >
> > > Yes. However, unless you are using a FAT32 or an NTFS 4 disk
> > > it's not the size of the file, but the number of rows being read. The
> > > absolute number of row slots for a single table is 2^32 (just over 2
> > > million). So - once the SP has walked past 2,147,483,648th row (or
> >perhaps
> > > a few less) the number is up, literally.
> >
> >So, the maximum number of rows in a Firebird table is just over 2
> Theoretical limit. The row slot enumerator is a 32-bit unsigned integer.
> Deleted rows, as well as uncommiitted and obsolete record versions still
> occupy slots. I believe Nickolay bumped that up to a higher power in Fb
> though I have a vague memory that it's not a 64-bit integer, maybe
> 2^40. (Which reminds me, I don't think that got into the Fb 2 alpha
> release notes...) Blobs that are stored on data pages play a part in
> lowering the theoretical limit, too.

Hmmm - 2 million rows per table is, well, not a whole lot ... :-/

With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Upscene Productions
Database development questions? Check the forum!