Re: Re: Many columns (as FK) vs 3x more Columns (in the same table)
Matt Pelmear <[email protected]>
| Newsgroups | gmane.comp.php.database |
|---|---|
| Message-ID | <[email protected]> |
I'm a little confused here. You have a 15x3x3 set of data to display in a 3 column, 15 row datagrid? Are you displaying a single value in each cell of the datagrid, or all 3 values for the cell? How many variables are needed to uniquely select a piece of data from that 3-dimensional space? Can you provide a little more detail about the data? -Matt On 09/19/2012 11:44 AM, Bruno Sandivilli wrote: > Anyone? Please. > > 2012/9/18 Bruno Sandivilli <[email protected]> > >> Hi, i strugling to decide what is the best choice: >> >> I have a 15 row x 3 columns Flash DataGrid, it means, for each row i have >> 3 values. >> To represent this in my Database, I could: >> >> >> 1. Create 2 Tables : A Values table - with 3 columns ; and a Bill >> table (with 15 foreign keys, each one pointing to one row in the Values >> table). >> 2. Create one Table with 45 columns (15 fields * 3 values for each >> field). >> >> I want to know, wich is the best choice? >> To manage my query, now i have a SELECT with a thousand of leftJoins. >> >> This is the best choice? >> >> How could I run a query wich will give all results linked, like: >> ( column_1_val_1, column_1_val_2, column_1_val_2, >> column_2_val_1, column_1_val_2, column_1_val_3, >> etc...) ? >> >> Thanks! >> >> -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php