Hi svanderclock,

Interesting case, how fast do you want it retrieved ?

per integer/smallint field will generate 8 byte index data
(25 columns * 8 byte * 50~~) will get you ~9.7 gb
ref: http://www.volny.cz/iprenosil/interbase/ip_ib_indexcalculator.htm

so i would go for 64 bits system with lots of memory to keep index data in the cache of the running OS (win or linux).

(btw it will be more a hardware issue then software issue)

Cheers,
Derryck

--- In firebird-support@yahoogroups.com, "svanderclock" <svanderclock@...> wrote:
>
> hello,
>
> I need to store 25 values (integer) in 25 differents fields.
> all the value are from 0 to 255 (8bit). their will be at the end more than 50 000 000 rows in the table !
>
> What field definition to choose to store only 8 bit ?
>
> after i will select the field only in the way
>
> select ID from table colors where
> color1 > 120 and color1 < 140 and
> color2 > 160 and color2 < 180 and
> color3 > 60 and color3 < 80 and
> ...
> color25 > 20 and color25 < 40;
>
> is this will be acceptable under firebird ?
> or too much heavy ? did i will need to create only
> one multi column index or 25 single column index ?
>