Re: [GENERAL] Is It Good Practice That I use TableName-Month-Year Convention

2010-01-13 Thread Tino Wildenhain
Hi, Am 13.01.2010 09:16, schrieb Yan Cheng Cheok: I realize the READ performance goes down dramatically when my table goes large. Every new day goes on, my table can increase x millions of new rows. I was wondering whether this is good practice I can design my database in this way? Instead o

[GENERAL] Is It Good Practice That I use TableName-Month-Year Convention

2010-01-13 Thread Yan Cheng Cheok
I realize the READ performance goes down dramatically when my table goes large. Every new day goes on, my table can increase x millions of new rows. I was wondering whether this is good practice I can design my database in this way? Instead of having lot <-> unit <-> measurement Can I have l