If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > General > Database Concepts & Design > need help about Database Performance

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 06-14-06, 03:22
iameak_69 iameak_69 is offline
Registered User
 
Join Date: Jun 2006
Posts: 2
need help about Database Performance

i create a table and in thai table have one field that field usually have NULL values. is performance of my database has been down

ex of my db

field1 field2 field3
001 001 NULL
002 003 NULL
004 001 a
005 006 NULL

like this is performance of my db is poor ?

forgive my english i'm not good in english
Reply With Quote
  #2 (permalink)  
Old 06-14-06, 04:05
healdem healdem is offline
Jaded Developer
 
Join Date: Nov 2004
Location: out on a limb
Posts: 9,246
what is the problem you think may exist
what made you ask the question

on the face of it the desing looks fine
the only problem I can see would be calling your column (field) names field1, field2, field3 - its generally better practise to give them meaningfull names. For example for a table holding an address

AddressLine1 or AddrLine1
AddressLine2 or AddrLine2
AddressLine3 or AddrLine3
AddressLine4 or AddrLine4
AddressLine5 or AddrLine5
PostCode
Country

alternatively
AddressLine1 or AddrLine1
AddressLine2 or AddrLine2
Town
City
County
PostCode
Country

in my view the only possible problem is how you have defined the 3rd column, the one that stores the nulls - does the db you are using support a varaible length datatype (memo, varchar etc...), and if so are you using that data type. It doenn't matter if the column size is small but if its large then it could have a slight impact on performance.
...and that problem only relates to storage and may have a minor impact on retrieval performance.
__________________
I'd rather be riding my Versys or my Tiger 800 let alone the Norton
Reply With Quote
  #3 (permalink)  
Old 06-14-06, 08:25
iameak_69 iameak_69 is offline
Registered User
 
Join Date: Jun 2006
Posts: 2
explore

i use MS SQL Server 200 and design my database for my explore

in my explore form have 5 question and user can comment anything to me my database is like this

AnswerOfQuestion_01
AnswerOfQuestion_02
AnswerOfQuestion_03
AnswerOfQuestion_04
AnswerOfQuestion_05
CommentToMe

people seldom fill comment to me it make my databse have a lot of NULL value in filed CommentToMe

i want to know this make performance of my database come poor
it have only one problem that it will have a bigger size, that right ?
it don;t make my database slower ?

sorry, if i ask my question don't clear

thank you for your answer
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On