What kind of data are stored in table?
Do you search in this table?
If this is some historical logs (e.g. GPS position of vehicle) then you should divide data not in several tables but in several databases e.g. monthly data then your "master" database will be small,
faster backup/restore process and easy maintain

Karol Bieniaszewski

--- In firebird-support@yahoogroups.com, Vander Clock Stephane <svanderclock@...> wrote:
>
> actually except during backup restore, no ... but i want to know with
> probleme i will face :)
>
> On 12/28/2011 8:18 PM, Milan Babuskov wrote:
> >
> > Vander Clock Stephane wrote:
> > > Actually i have a table with more than 100 millions rows :( and it's
> > > growing growing, i thing we will be around 200 millions rows next
> > years ...
> > > is it bad ? or did i need to start to think to split the data in
> > several
> > > table ?
> >
> > Do you have any problems with it?
> >
> > --
> > Milan Babuskov
> >
> > ==================================
> > The easiest way to import XML, CSV
> > and textual files into Firebird:
> > http://www.guacosoft.com/xmlwizard
> > ==================================
> >
> >
>
>
> [Non-text portions of this message have been removed]
>