Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2013

    Unanswered: help required table design

    i have plan to create a analytic's table. Monthly approx 1 million records will be inserted to the table. How can i optimize the table and also fetch records fast way?
    If only one table is there then within an year my table would be huge and it will reflect performance so Alternatively i have planned to split the table monthly (Running a cron on server to create table) all insertions will insert rows to respective month table and while fetching the records i know how many table i need to take by using SHOW TABLES LIKE 'web_analyics_%' and i will use "union all" and generate the results.
    Is this better way to design the tables or is there any other way?

    Please advise on database and table design

  2. #2
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    a million rows a month is hardly huge.
    if it were a million rows per hour hour then I'd be starting to get concerned

    what is your evidence to back up your assertion
    my table would be huge and it will reflect performance

    a properly designed table, with a competant indexing strategy should be able to handle your requirements.

    as you db gets bigger you may need to consider the hardware its running on to maintain performance. that may mean more memory, more capable processors, better netwrok infrastructure and so on. most of that should be handled by a competent DBA experiecned in MySQL
    I'd rather be riding on the Tiger 800 or the Norton

Tags for this Thread

Posting Permissions

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