-
Moderator
- Rep Power
- 27
RDMS Design Help
I have a little issue that I am trying to fix here. We have a helpdesk with a SQL backend. The wonderfully people that set this thing up decided to use SQL, but not only did not normalize the database, they have absolutely no primary or foreign keys established.
What I am trying to do is normalize the database and set it up better, so that way I can program a Java frontend for it.
The current call log table has the following fields
Problem - LONGVARCHAR
WorkInProgress - LONGVARCHAR
Resolution - LONGVARCHAR
Each one of those fields represent a fair amount of input based on the call. I am thinking that part of the slow down in retrieving records is because of all of this information being placed on 1 row. Plus there is very little searching that can be done in a timely matter on these fields.
I want to separate them out to another table. What was suggested to me was to make a completely separate table that will have all this information in there and the link the Call log table up to it. I was thinking about having 3 separate tables, each one based off of these fields and then linking them up to the table.
Which method do you guys think is the best way to go? A single table that will be updated based off the information or 3 separate tables for this information?
Brian K. Errickson (aka Just) June, 12th 1975 - June, 12th 2003
You were my friend and the brother I never had. I love you man and I hope now all the pain has gone away. May god rest your soul.
"By these requirements, if someone digs up a 3-billion-year-old skeleton, we can toss Evolution from science class. So, if you don't want Evolution in science class, start digging!"
Similar Threads
-
By Hexum in forum General Discussion
Replies: 0
Last Post: 12-16-2002, 11:27 AM
-
By =[*NoXIous*]= in forum Graphic or Web Design and Programming
Replies: 1
Last Post: 08-26-2002, 10:41 PM
-
By Jazwana in forum Graphic or Web Design and Programming
Replies: 1
Last Post: 04-27-2002, 11:45 PM
-
By Nicole in forum Graphic or Web Design and Programming
Replies: 3
Last Post: 04-26-2002, 09:56 AM
-
By Jazwana in forum Graphic or Web Design and Programming
Replies: 2
Last Post: 04-22-2002, 01:42 AM
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
< Contact Us -
>
Powered by: vBulletin Version
Copyright ©2000, 2001, Jelsoft Enterprises Limited.
Bookmarks