Subject | Re: Table more more than 100 millions rows ? |
---|---|
Author | karolbieniaszewski |
Post date | 2011-12-30T12:36:20Z |
Then i do not see any problem with this
only size of database ;-)
slowdown will be small when database enlarge
look also at firebird limitation doc - record count per table (its big but i do not know what FB version you use)
http://www.firebirdfaq.org/faq61/
for faster lockup i recommend you to use 16K db page size and the same size of formatted Hard Drive Block
then index deep will be small
Karol Bieniaszewski
only size of database ;-)
slowdown will be small when database enlarge
look also at firebird limitation doc - record count per table (its big but i do not know what FB version you use)
http://www.firebirdfaq.org/faq61/
for faster lockup i recommend you to use 16K db page size and the same size of formatted Hard Drive Block
then index deep will be small
Karol Bieniaszewski
--- In firebird-support@yahoogroups.com, Vander Clock Stephane <svanderclock@...> wrote:
>
> >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
>
>