If you are using QAD MFG/PRO prior to eB, your sample database may not have the database areas nicely partitioned for you. This is largely due to the fact that those versions were created under Progress V8 and it did not have database areas. In the later version of MFG/PRO, QAD has made an effort to group the database tables into database areas and that makes the application much faster especially when running processes like the MRP.
You will notice that large tables are seperated into different areas and you can place them strategically to enhance your system performance. Of course if you have stripping of your disks, it may not have that much impact.
If you have a system that does not come with pre-defined database areas or you have upgraged from V8 to V9 or V10, you may want to consider re-arranging your database tables into different areas to improve your system performance. Before doing that, you need to analyse your database to know the sizes of each database table and the nature of transactions or access. Then you can re-group them and allocate the appropriate number of areas you need. For example, try to split the heavy transactional tables into different areas and balance them out.
