Thread: help required table design
07-18-13, 03:20 #1Registered User
- 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
07-18-13, 03:57 #2Jaded Developer
Provided Answers: 59
- Join Date
- Nov 2004
- out on a limb
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 assertionmy 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 MySQLI'd rather be riding on the Tiger 800 or the Norton