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 5 of 5
  1. #1
    Regular Coder
    Join Date
    Jul 2002
    Location
    Bunbury W.A
    Posts
    157
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Whats the most efficient way in access

    What is more efficient in the overall size of d/b
    haveing all the fields in one table or creating seperate tables for various sections of sie
    eg
    Content - id - users - name-age - address - guestbook - message - date -news - hit - url - etc etc
    or
    content - id - news
    users - id - name - age - address
    gusetbook id - message -date

  • #2
    Regular Coder
    Join Date
    Jul 2002
    Location
    Raleigh, NC
    Posts
    484
    Thanks
    0
    Thanked 0 Times in 0 Posts
    personally, I think it is faster to have all of the fields in the same table. As long as you only select the fields you want to display and not just select * the db should run efficiently. Making connections to various tables adds time to loading dynamic content.
    -WebMark Art
    Programming is 80% thinking and 20% spelling

  • #3
    raf
    raf is offline
    Master Coder
    Join Date
    Jul 2002
    Posts
    6,589
    Thanks
    0
    Thanked 0 Times in 0 Posts
    It depends.

    Database design is just as difficult as important. With a good design, you can have fast access to the required data, without hugh updatingproblems (updating, insertion or deletion anomaly's) Your design will depend on what data you need to insert/select/update in each connection, and on the kind of data (is it updated frequently, do you reuse a lot of data (over time, over records), ...)
    Also, if you need to be able to track the changes in your database (who made them? when?), it's in most case best to spread the data over a few tables.


    With the data from your example, I don't think it will be moderated frequently so you might as well put it in one table

  • #4
    Senior Coder
    Join Date
    Jun 2002
    Location
    41 8' 52" N -95 53' 31" W
    Posts
    3,660
    Thanks
    0
    Thanked 0 Times in 0 Posts
    What raf said. You're probably better off studying relational database design first, and then worrying about efficiency.
    Former ASP Forum Moderator - I'm back!

    If you can teach yourself how to learn, you can learn anything. ;)

  • #5
    New Coder
    Join Date
    Aug 2002
    Posts
    73
    Thanks
    0
    Thanked 0 Times in 0 Posts
    In relational databases, there is a correct way of designing tables. It is through a process called "normalization". A fully normalized database has no duplicate information and will be smaller than one that isn't normalized.

    Often times in a web environment, a fully normalized design may not be desirable, especially when efficiency is a factor and you are joining large amounts of records.

    According to Microsoft, there are two different ways you can use a database, 1) Data Warehousing - where you collect information and give reports. If you this is how you are using the database, you may want to leave it unnormalized. 2) Online Analytical Processing - where you are constantly doing updates, inserts, deletes, etc. (like a forum ) you want to have it as normalized as possible.

    ryn

    If you have access to the MS-SQL Server CD, see the Microsoft documentation for Database Design Considerations.

    "people tend to hate me cause I never smile
    as I ransack their home, they want to shake my hand"
    -The Who The Seeker


  •  

    Posting Permissions

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