View Full Version : Processing through the Database or ASP?

01-26-2005, 06:27 PM
Hi Folks,
I guess my situation's somewhat similar to http://www.codingforums.com/showthread.php?t=50861 but i just want to hear your opinions.
I have a database and i have values that resemble
value1 = "COLOR - Red"
value2 = "COLOR - Blue"
value3 = "COLOR - White"
value4 = "COLOR - Yellow"
value5 = "SIZE - Big"
value6 = "SIZE - Smal"l
value7 = "SIZE - Medium"
value8 = "FONT - Arial"
value9 = "FONT - Comic"

Note: i'm just using values everyone would understand.
I want to store those values in the database for every user and display them later. I'm looking at two options.
1. Remove the first parts of the values and store only Red, Blue, White, Yellow, Big, Small,.. etc. Then, when i want to display them i use a SELECT CASE statement to add the parts I initially removed.
I initially chose this option so i could optimise database size considering the fact that i might have over 10,000 users.

2. After going through the thread http://www.codingforums.com/showthread.php?t=50861 and seeing:

The database engines that drive these various databases are built to be very efficient at retrieving data according to the SQL they are executing. , i'm beginning to think i should just store the whole string into the database instead of cocantenating it. This way i won't have to run any ASP code after reading from the database. I'll just display what is in the databse. I'm looking at optimising speed and server resources with this option.

I need some advice about what option is best cos i don't want to complete the application and then have to change it later when the database is full and everything becomes cumbersome.
The question's probably dumb, but all help will be appreciated.

01-26-2005, 10:10 PM
It depends on what the data is and how you are going to use it. Do you need to store these things as entities and attributes? i.e. need to pick out the contituant parts?

If so, you may not have to store as a long string or put it back together in you ASP...it depends...