0

I want to store codes in a database i.e title code, status code, etc. I want to do this without affecting the performance of the database. I want u guys to tell me the most advisable way of doing this. I want to retrieve the actual code descriptions using these codes in the fastest time possible. I'm wondering if i should store them in multiple tables or in one. Ans how do i go about doing that.

Thank you

3
Contributors
7
Replies
8
Views
8 Years
Discussion Span
Last Post by debasisdas
0

It is always faster accessing 1 table instead of multiple tables. Not quite sure what else you want in the table but try something like this would most likely be best

ID Code Code_Description ...Other fileds
1 Status desc
2 Title desc
....

0

From your post i am not sure what exactly you are looking for . Why you need to store the codes in database . What is the database that you are using ?

0

From your post i am not sure what exactly you are looking for . Why you need to store the codes in database . What is the database that you are using ?

I need to store codes such as title code, status codes, etc. I need to use this codes to retrieve their respective information. This needs to happen as fast as possible as i'm working on a web-based system. I was thinking of storing them in different tables but i don't know if this is going to affect the performance of the database. I am using Oracle.

0

Like I told you in my earlier post, 1 table is always faster.

You should also use an index if you want to increase scanning speeds as index scans are faster than table scans.

0

It is not advisable to store all the code into one table. but if you want store those with some flag setting . Always create index for faster access of data.

0

I want to store codes in a database i.e title code, status code, etc. I want to do this without affecting the performance of the database. I want u guys to tell me the most advisable way of doing this. I want to retrieve the actual code descriptions using these codes in the fastest time possible. I'm wondering if i should store them in multiple tables or in one. Ans how do i go about doing that.

Thank you

@debasisdas The user is looking to setup a lookup table for his status codes not store all his data in one table.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.