So, which is the limit of the table size and why is failing the
import?

I just have tried to split the file in two 17 million rows files. The
first file is copied into internal file without problems in 45
minutes, but the second one has failed (the process is still running
after 3 hours processing)

Diego


--- In firebird-support@yahoogroups.com, "Martijn Tonies"
<m.tonies@u...> wrote:

> > >>>>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