Journal Journal: Help: Derby DB Issue
Having some issues with derby and understanding why it may be as such.
I have two table in my DataBase
Table A:
Int
varchar(500) The values have an average length of 19 with a std dev of 10
Table B:
Int
Int
SmallInt
So the Ints are 2 Bytes, the SmallInt 1 Byte, and the varchar ( god help me ) is as small as need be.
I have 2 million record in Table A, 3.5 Million in Table B.