Re: Opinion on table structure and accessibility

On 16 Mar, 14:45, "gl" <stin..._at_pd.jaring.my> wrote:
> Hey guys, need expect opinion on table design and access. For a loan
> record which going to store 300 months of principal outstanding and
> interest outstanding. Which is a better choice?
>
> 1) Create a table with data structure as
> loan_no, month_no, prin_os, int_os
>
> 2) create a table with
> loan_no, p_mth1, p_mth2, p_mth3 ... p_mth300.
>
> The first method will have million of records which cause I/O
> contention, the second method will have issue on selecting data
> randomly. Is there any other way for this design? Thank you.

Solution two is horrible. Always think vertically in design.

HTH -g Received on Fri Mar 16 2007 - 09:50:39 CDT