Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2005

    Performance issue on large Data Table Design

    We have a Consumer_Data Table which contains quite a lot of columns
    like Name, phone, Mobileno, address, city, state, hobbies, birthday, CompanyName, CompanyPhone... etc.

    Over the years we have over millions of data and queries run on this Consumer_Data table begin to take long time, especially for some very complex one.

    Current table has indexes or so to help on some frequent run query.

    Now I'm thinking of re-do the Table structure that will increase the overall query performance and would like to get some suggestions.

    Please share some thoughts and much appreciated.

  2. #2
    Join Date
    Sep 2002
    Presumably you don't have millions of rows in your Consumer_Data table, since it is one row per person and I assume you don't serve that many people? And I don't see many columns either - how many are there in fact? So maybe your problems come from somewhere else - it's impossible to say based on the information we have. It could just be you are missing a required index, or that your optimiser needs up-to-date statistics that haven't been gathered.

  3. #3
    Join Date
    Jun 2004
    Arizona, USA
    And, what is the database type?
    "Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
    "I have my standards. They may be low, but I have them!" - Bette Middler
    "It's a book about a Spanish guy named Manual. You should read it." - Dilbert

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts