Subject Re: Data type for flags
Author ainpoissee
--- In, Dimitry Sibiryakov <sd@...> wrote:
> Use Integer.

It would send 4 bytes while one would do... as I sayd a lot of those records would be sent back and forth between client and serves and to optimize for speed I want to make the size of one row as small as possible. I know it looks like a premature optimization but my past expierence is that pulling data from DB is the main bottleneck in the kind of app I'm creating.

If there is a good reason not to use CHAR(1) then at least SMALLINT would be better than INTEGER in case only 8 bits is required, no?

BTW, I now noted that size of NUMERIC and DECIMAL is documented as "variable, 16, 32 or 64 bits" so perhaps NUMERIC(1) is still a good way to go?