Hello and welcome to our community! Is this your first visit?
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    Regular Coder
    Join Date
    Oct 2004
    In front of this computer. (Where else?)
    Thanked 0 Times in 0 Posts

    Processing through the Database or ASP?

    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:
    Quote Originally Posted by factalvibes
    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.
    Last edited by tboss132; 01-26-2005 at 06:29 PM.
    Tomorrow is the first day of the rest of your life... What have you done today?
    Web: w3schools, htmldog General tips: Hardware, Networking

  • #2
    Regular Coder
    Join Date
    Aug 2002
    Thanked 0 Times in 0 Posts
    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...



    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts