> >>>>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?
> >
> >
> >Hmmm - 2 million rows per table is, well, not a whole lot ... :-/
> >
> >
>
> 2^31 is around 2 billion, not 2 million - or am I missing something?

Hmm, right. I guess both Helen and me are missing something :-)

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