DavidPr Posted October 9, 2007 Share Posted October 9, 2007 I have a database with a 50 tables, one for each state in the US. However, this makes it difficult to perform certain maintenance procedures - like removing outdated information. I have a php script that will search for data that is over 45 days old and delete them when a button is clicked. I'm currently having to do this for each table and it's a pain.Is there a limit as to how much information a table can hold? Or before it begins to suffer performance wise?I'd like to combine the now 50 tables for each state into just one table and identify the data for a specific state with the 2 digit abbreviation like GA for Georgia. This table has the potential to collect quite a bit of data, but with removing data over 45 days old every week will help. Right now the combined data in all the tables could easily fit in one table, but I'm thinking about the future.ThanksDavid Link to comment Share on other sites More sharing options...
justsomeguy Posted October 9, 2007 Share Posted October 9, 2007 The size is only limited by the disk size that the database is on. For performance, you can define indexes on certain fields that you search for often (like the state name). Indexes will help the speed any time you search for fields based on an index, but they also need to get updated every time you do an insert or update so don't define more indexes then you need. Link to comment Share on other sites More sharing options...
DavidPr Posted October 9, 2007 Author Share Posted October 9, 2007 OK, thanks.David Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.