hello, i have 2 tables
Table1 74 fields Total size of one row: 4302 bytes Table2 65 fields Total size one row: 4786 bytes theses tables are link by a 1=1 relation. around 10 000 000 rows in each table Is their any advantage to keep the data in 2 tables instead of one ? i can eventually reduce the size on the row to make that it's can fit inside a page of the database (8192) but it's a huge job to do, so before to start it prefere just to have your opinion ...
