|
Noor Anwar
Starting Member
8 Posts |
 Posted - 2010-08-26 : 00:57:15
|
| How many Partitioned tables(with a no of ranges per table)are supported by a partitioned database.in sql 2005.and my problem is that i have round about 35 tables for a hospital database that will be partitioned (for a number of ranges(Union All/no of objects per table)) with insertion,updation, and retrieval of most rcent data.(old data also needed but per month and per year counting of patients from old data and audit of data queries.and 70 same applications running on clients that will retrieveinsert and update data simultaneously rapidly.that per month records insertion per table is 1 lakh and more.while most 70% of data with Patientid is retrieved in where clause of select statement from multiple clients simultaneously.and my question is that how tables may be partitioned to achieve optimal performance data is retrieved on date,patientid,and department id basedwhile departmentid is in only one in patient's tablepatientid base queries are regular on daily basis but department based are monthly or annualy facts and figures are required.eg;pk for primary key and fk for foreign keytblpatient(patientid pk,departmentid,datetime,name,father.........)tbldisease(sr pk,Patientid fk,datetime,...,.........)tblinvestigation(sr pk,patientid fk,datetime,....,...)tblprescreption(sr pk,patientid fk,datetime,..........tblinstruction(sr pk,patientid fk,datetime, ............tblmedicine(sr pk,patientid fk,date...........tblhaematoloty(sr pk,patientid fk,datetime.........tblclinicalchemistry(sr pk,patientid fk,dateit........tbl..........tbl...............tblusg(sr pk,patientid fk,datetime,..........,.....)tblxray(sr pk,patientid fk, datetime, .....,bodyregion,...)A single Table Example Required Can anybody help me |
|
For Performance How many Partitioned tables