AW: Table partitioning functionality

2002-09-06 Thread Moestl, Wolfgang
Hi Daniel, So what would be a good solution within MySQL to store large amounts of data if they have to go into a single table? InnoDB seems to be the right table type to use (especially as they support transactions as well) but you do not have controll over the used tablespace. They are just

AW: Table partitioning functionality

2002-09-06 Thread Antoine
Hi, You could do the partitioning logic on the application side. For example you can create a new table every month with a different suffix corresponding to the year/month number. Then you add the info about this new table into a master description table, which holds one row per created table,