Hi,

Currently at my hosting company, we are using MySQL 5.0. All our
tables are of InnoDB type. I chose this at one time b/c it supported
use of foreign key constraints. My hosting company now tells me
InnoDB tables are not optimized for disk usage reporting in real
time. My questions are:

1. Is there another table type I can use that supports foreign key
constraints that is better for disk usage reporting?

2. Is there another table type I can use that supports foreign key
constraints and uses less disk space?

3. How can I change the type of a table without losing the data?

Thanks, - Dave