Hi Martijn,


Martijn Tonies wrote:

>>>Is the file too big to do the import?
>>
>>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
>
> perhaps
>
>>a few less) the number is up, literally.
>
>
> So, the maximum number of rows in a Firebird table is just over 2 million?

To me the above looks more like 2 billion rows, i.e. a million has 6
zeros and a billion as 9 zeros - No? :)

See you
Werner

>
> 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
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>