The limit is definitely not 2 million. We have plenty of tables with
over that limit. However, our largest is only around 19 million.

-steve

On Wed, 2005-08-24 at 15:58 +0000, zimrilin2000 wrote:

> 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
>
>
>
>
> ------------------------ Yahoo! Groups Sponsor
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> 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
>
>
>
>
>
>
>
>


[Non-text portions of this message have been removed]