Bpk. Adi Wira Kusuma
Guest
|
 Posted: Thu Apr 12, 2007 10:46 am Post subject: best performance? |
 |
|
What is ur opinion ? i've 2 model db.
1)
CREATE TABLE [dbo].[TDTRANS] (
[ID_TRANS] [int] NOT NULL ,
[NU] [smallint] NOT NULL ,
[IDBRG] [int] NOT NULL ,
[KODELINK] [char] (1) COLLATE Latin1_General_CI_AS NULL ,
[NOLINK] [varchar] (15) COLLATE Latin1_General_CI_AS NULL ,
[RPBAHAN] [float] NOT NULL ,
[RPFINIS] [float] NOT NULL ,
[JMLBAIK] [float] NOT NULL ,
[JMLREJEK] [float] NOT NULL ,
[KETR] [varchar] (35) COLLATE Latin1_General_CI_AS NULL
)
CREATE TABLE [dbo].[TMTRANS] (
[ID_TRANS] [int] IDENTITY (1, 1) PRIMARY KEY,
[REFF] [varchar] (15) COLLATE Latin1_General_CI_AS NOT NULL ,
[TGL] [datetime] NOT NULL ,
[IDMEMBER] [int] NULL ,
[IDREGU] [int] NULL ,
[NOSJ] [varchar] (12) COLLATE Latin1_General_CI_AS NULL ,
[TGSJ] [datetime] NULL ,
[DATEIN] [datetime] NULL ,
[IDUSER] [int] NULL
)
2)
CREATE TABLE [dbo].[TDTRANS] (
[REFF] [varchar] (15) COLLATE Latin1_General_CI_AS NOT NULL,
[NU] [smallint] NOT NULL ,
[IDBRG] [int] NOT NULL ,
[KODELINK] [char] (1) COLLATE Latin1_General_CI_AS NULL ,
[NOLINK] [varchar] (15) COLLATE Latin1_General_CI_AS NULL ,
[RPBAHAN] [float] NOT NULL ,
[RPFINIS] [float] NOT NULL ,
[JMLBAIK] [float] NOT NULL ,
[JMLREJEK] [float] NOT NULL ,
[KETR] [varchar] (35) COLLATE Latin1_General_CI_AS NULL
)
CREATE TABLE [dbo].[TMTRANS] (
[REFF] [varchar] (15) COLLATE Latin1_General_CI_AS NOT NULL PRIMARY KEY,
[TGL] [datetime] NOT NULL ,
[IDMEMBER] [int] NULL ,
[IDREGU] [int] NULL ,
[NOSJ] [varchar] (12) COLLATE Latin1_General_CI_AS NULL ,
[TGSJ] [datetime] NULL ,
[DATEIN] [datetime] NULL ,
[IDUSER] [int] NULL
)
I fell that model 1 has best performance, Because field ID_TRANS is field
key of relation and it only need 4 bytes.
But, when i wanna add the data to other db/server (have same struktur), Is
it not erorr? how to solve it?
I use Sql Server 2000 |
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
