Subject Re: [firebird-support] Re: Table more more than 100 millions rows ?
Author Vander Clock Stephane
>What kind of data are stored in table?

it's simple the id of the picture associate to each item in the database.
we access the data in the database only through query like

select ... where ID = xxx


On 12/30/2011 11:24 AM, karolbieniaszewski wrote:
>
> 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
> <mailto:firebird-support%40yahoogroups.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]
> >
>
>


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