Is It Good Practice That I use TableName-Month-Year Convention
| От | Yan Cheng Cheok |
|---|---|
| Тема | Is It Good Practice That I use TableName-Month-Year Convention |
| Дата | |
| Msg-id | 558771.51019.qm@web65703.mail.ac4.yahoo.com обсуждение исходный текст |
| Ответы |
Re: Is It Good Practice That I use TableName-Month-Year
Convention
|
| Список | pgsql-general |
I realize the READ performance goes down dramatically when my table goes large. Every new day goes on, my table can increasex 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 lot-March-2010 <-> unit-March-2010 <-> measurement-March-2010 lot-April-2010 <-> unit-April-2010 <-> measurement-April-2010 (1) That's mean in my stored procedure, I need to dynamically generate the table name. Is this the "dynamic SQL" to correctway, to dynamically generate table name : http://www.postgresql.org/docs/8.1/interactive/ecpg-dynamic.html (2) Is this consider a good approach, to overcome speed problem (especially read speed). Any potential problem I should putan eye on, before I implement this strategy? Thanks and Regards Yan Cheng CHEOK
В списке pgsql-general по дате отправления: