1 Reply Latest reply on Jan 11, 2010 8:27 AM by mrvodka

    Is relying on relationships too slow?

    typeleven

      Title

      Is relying on relationships too slow?

      Post

      <!-- [if gte mso 9]><xml> <w:WordDocument>   <w:View>Normal</w:View>   <w:Zoom>0</w:Zoom>   <w:PunctuationKerning/>   <w:ValidateAgainstSchemas/>   <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid>   <w:IgnoreMixedContent>false</w:IgnoreMixedContent>   <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText>   <w:Compatibility>    <w:BreakWrappedTables/>    <w:SnapToGridInCell/>    <w:WrapTextWithPunct/>    <w:UseAsianBreakRules/>    <w:DontGrowAutofit/>   </w:Compatibility>   <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel> </w:WordDocument> </xml><![endif] --><!-- [if gte mso 9]><xml> <w:LatentStyles DefLockedState="false" LatentStyleCount="156"> </w:LatentStyles> </xml><![endif] --><!-- /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal      {mso-style-parent:"";      margin:0in;      margin-bottom:.0001pt;      mso-pagination:widow-orphan;      font-size:12.0pt;      font-family:"Times New Roman";      mso-fareast-font-family:"Times New Roman";} p      {mso-margin-top-alt:auto;      margin-right:0in;      mso-margin-bottom-alt:auto;      margin-left:0in;      mso-pagination:widow-orphan;      font-size:12.0pt;      font-family:"Times New Roman";      mso-fareast-font-family:"Times New Roman";} @page Section1      {size:8.5in 11.0in;      margin:1.0in 1.25in 1.0in 1.25in;      mso-header-margin:.5in;      mso-footer-margin:.5in;      mso-paper-source:0;} div.Section1      {page:Section1;} --><!-- [if gte mso 10]> <style> /* Style Definitions */ table.MsoNormalTable      {mso-style-name:"Table Normal";      mso-tstyle-rowband-size:0;      mso-tstyle-colband-size:0;      mso-style-noshow:yes;      mso-style-parent:"";      mso-padding-alt:0in 5.4pt 0in 5.4pt;      mso-para-margin:0in;      mso-para-margin-bottom:.0001pt;      mso-pagination:widow-orphan;      font-size:10.0pt;      font-family:"Times New Roman";      mso-ansi-language:#0400;      mso-fareast-language:#0400;      mso-bidi-language:#0400;} </style> <![endif] -->

      Im moving an old FM5 database to FM10 I have two ways I think I can do this. My example will be the clients table, there are currently over 18000 of them. So I’m concerned about the speed of browsing records and possibly over the WAN.

       

      I could make a table with all the fields that they need for each client ( first name, last name, phone, address, etc) right now they have about 80 fields, one of there tables has 300 fields! It looks like they kept adding a field when they wanted to add something like another address or another phone number. I want to keep the tables from getting like they currently are (300 fields x 10,000+ records). Im guessing though for browsing the records it is faster than my following Idea.

       

      I want to make a clients table that is just the ID_pk field. Then have an attributes table, this table has three fields, ID_fk, type, data. So through the table relationship I will have the information about each client. For example an Attribute will be [CID1, First Name, John] and then [CID1, Last Name, Smith] So now I have the first and last name assigned to the first client. This will be added via a portal. So now I can assign an infinite number of attributes to a record.

       

      With over 10,000 records will having to rely on relationships be too slow over the network or WAN? Id like to know before I spend days on the scripts to import everything :)