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.