Subject | Re: [firebird-support] import data from external table (huge file) |
---|---|
Author | Martijn Tonies |
Post date | 2005-08-24T14:29:22Z |
> >Is the file too big to do the import?perhaps
>
> Yes. However, unless you are using a FAT32 or an NTFS 4 disk partition,
> 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
> a few less) the number is up, literally.So, the maximum number of rows in a Firebird table is just over 2 million?
With regards,
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com