Table structure?

[Ruslan Zasukhin]

On 4/28/06 8:10 PM, "Joakim Schramm" <joakim at astrocalc.com> wrote:

Hi Joakim, 

> I would like to ask for advice in a db/table structure question, if my idea
> I have about would matter in any sense to Valentina (VCOM).
> 
> I want to set up a db to import a lot of data from it's current source and
> have decided to go for binary links right away although it's completely new
> to me. It looks briliant though at least on paper.
> 
> Anyhow, my dataset basically consist of 2 parts, now stored in 2 tables. The
> first table has about 220 000 records and the second table has about 500 000
> records. As my current datasourse isn't relational in a true sense I link
> that bit in code now and the second table serve as something like a "lookup"
> table for items of the first table. But each item in T1 only look for data
> within a limited range of the whole data in T2, and several items can look
> for same data so one could say it's something of a M:M relation. Important
> to mention as well is that the T2 data need to be in a certain sequencial
> order, either in the db or as it's returned for evaluation (like in an array
> as it's returned now).
> 
> So my question is; I can devide the 500 000 records in to about 300
> "logical" groups related to certain records in T1, would it be an idea to
> split up this data in say 300 tables to easily exclude most of the
> irrelative data to lookup in?

No, this is bad idea I think.

Do you have in your table some field, WHICH divide records into 300 groups?
I.e. This fields have 300 distinct values?
I think you have such field, and it is ENOUGH...

We do not split into separate tables people born in 1970-1979 and 1980-1989.
Right?

Of course, in some rare projects may be this will have sense, but you have
generally speaking NOT huge database.


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]