Re: Split data over multiple mysql tables or leave in 1 table

2008-05-05 Thread Scott Stevens
Thanks for the help. Is there a version of MySQL that can handle partitioning? I looked on the MySQL website, it says it has partitioning in 5.1, but had the following disclaimer: The partitioning implementation in MySQL 5.1 is still undergoing development. Have you (or anyone else) had any

Re: Split data over multiple mysql tables or leave in 1 table

2008-05-04 Thread Rizal Firmansyah
Hi Scott, regardless of how many records you have (60,000 is small for DB though), i think it's better if the DB design and logic jobs are separated. Assuming you have a correct index, saving them all in one large table is ok. So, you can keep the current logic the same. If you really care about

Split data over multiple mysql tables or leave in 1 table

2008-05-03 Thread Scott Stevens
I'm building an application where the amount of data in a table will be growing fairly quickly. The particular application is a little complicated to explain, so for simplicity, let's say I was building a blog app in the following enviroment. Linux server w/apache MySQL 4.1 Coldfusion 7.02 I