Hello and welcome to our community! Is this your first visit?
Register
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
    Location
    In front of this computer. (Where else?)
    Posts
    442
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Processing through the Database or ASP?

    Hi Folks,
    I guess my situation's somewhat similar to GetRows or SELECT? 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 GetRows or SELECT? 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 05:29 PM.
    Tomorrow is the first day of the rest of your life... What have you done today?
    Tutorials
    Web: w3schools, htmldog General tips: Hardware, Networking

  • #2
    Regular Coder
    Join Date
    Aug 2002
    Location
    Texas
    Posts
    287
    Thanks
    0
    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...

    fv


  •  

    Posting Permissions

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