Results 1 to 6 of 6
  1. #1
    Join Date
    May 2012
    Posts
    2

    Spreadsheet database vs heavy database

    It's amazing, when thinking back, how much time I could have saved using a simple spreadsheet database instead of a heavy database. How often do you need anything more than the one found here SoftBox ? Do you experience something similar? Any ideas how to optimize an application like this? -Baseman
    Last edited by Pat Phelan; 05-03-12 at 11:50.

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    you can optimize a spreadsheet database by moving it to a real database, like microsoft access
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Quote Originally Posted by r937 View Post
    you can optimize a spreadsheet database by moving it to a real database, like microsoft access
    I just spit coffee all over my monitor

    real database...u funny
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  4. #4
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    it's a lot realer than excel

    for instance, access supports foreign keys

    but since the question was about optimization, it's the indexes that make the difference
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  5. #5
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    <soapbox>

    sorry, it's just greek to me

    "Heavy Database"

    "Spreadsheet Database"

    Hell I even know that the people involved in the Lotus Notes "Discipline" Call those "Things" Databases

    It's like anything in this industry, they make up some terminology, create new buzz words..and they, for who the heel knows what reason, stick

    There is NOTHING New under the son

    A pig is a pig, until someone calls it a thoroughbred....and people believe it for whatever reason...just like snake oil salesmen
    </soapbox>
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  6. #6
    Join Date
    Jul 2012
    Posts
    34
    why did you classify the databases ?? you choose the database according to your standards and requirements..

Posting Permissions

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