G
Gareth Vincent
Guest
I agree, it can get over complicated, especially when dealing with a database with over a few hundred tables. Below is an extract of the ST file i'm using for one of our DB's (over 500 tables). Table 1 - 15 have been highlighted as extremely high processing tables. For the others i've grouped on a per RPB/Cluster (bottom of ST file). I've also added a Misc storage area for the rats and mice and a separate area for BLOBS. This takes some careful planning and like James mentioned can change over time. d "Misc Data 128":9,128;8 db_9.d1 # d "Misc_IDX_Area":10,64;8 db_10.d1 # d "table1":11,64;512 db_11.d1 # d "table1_IDX_Area":12,64;8 db_12.d1 # d "table2_Area":13,64;512 db_13.d1 # d "table2_IDX_Area":14,64;8 db_14.d1 # d "table3_Area":15,64;512 db_15.d1 # d "table3_IDX_Area":16,64;8 db_16.d1 # d "table4_Area":17,32;512 db_17.d1 # d "table4_IDX_Area":18,64;8 db_18.d1 # d "table5_Area":19,128;512 db_19.d1 # d "table5_IDX_Area":20,64;64 db_20.d1 # d "table6_Area":21,16;512 db_21.d1 # d "table6_IDX_Area":22,64;8 db_22.d1 # d "table7_Area":23,128;512 db_23.d1 # d "table7_IDX_Area":24,64;8 db_24.d1 # d "table8_Area":25,64;512 db_25.d1 # d "table8_IDX_Area":26,64;8 db_26.d1 # d "table9_Area":27,64;512 db_27.d1 # d "table9_IDX_Area":28,64;8 db_28.d1 # d "table10_Area":29,32;512 db_29.d1 # d "table10_IDX_Area":30,64;8 db_30.d1 # d "table11_Area":31,128;512 db_31.d1 # d "table12_IDX_Area":32,64;8 db_32.d1 # d "table13_Area":33,64;512 db_33.d1 # d "table13_IDX_Area":34,64;8 db_34.d1 # d "table14_Area":35,32;512 db_35.d1 # d "table14_IDX_Area":36,64;8 db_36.d1 # d "table15_Area":37,32;512 db_37.d1 # d "table15_IDX_Area":38,64;8 db_38.d1 # d "128-512C":39,128;512 db_39.d1 # d "16-8C":40,16;8 db_40.d1 # d "16-512C":41,16;512 db_41.d1 # d "32-8C":42,32;8 db_42.d1 # d "32-512C":43,32;512 db_43.d1 # d "64-512C":44,64;512 db_44.d1 # d "64-8C":45,64;8 db_45.d1 # d "256-8C":46,256;8 db_46.d1 # d "256-512C":47,256;512 db_47.d1 # d "BLOB_area":48,1;512 db_48.d1
Continue reading...
Continue reading...