Subject Re: Table more more than 100 millions rows ?
Author karolbieniaszewski
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


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