4 Replies Latest reply: Oct 30, 2014 10:18 AM by Felim Shanaghy RSS

    Large volume data ?

    Richard Chilvers


      I have 2 tables: one containing a person_key and person details, and one containing the person_key and a mailshot_ID, plus mailshot details.

       

      The person key is a unique 6 digit number.

       

      There are roughly 750,000 persons and each one might receive 5 mailshots a year.

       

      I have simply linked the tables on the person-key. This does not seem huge volumes of data to me, but the resulting QV model seems large and slow.

       

      I have tried using AUTONUMBER on the person-key, but since the key is already well-structured, this makes little difference.

       

      Does anyone have any hints or tips about the approach?

       

      Sorry if this is a simple query, but I'm puzzled by the apparent poor performance.

       

      Thanks