www.webdeveloper.com
Results 1 to 3 of 3

Thread: What table type I shall use?

  1. #1
    Join Date
    Dec 2005
    Posts
    55

    What table type I shall use?

    Hello,

    I am working on the database that will have 5+ tables.
    These tables will be accessed for data entry, data modification, data searching and so on. Also these tables will be accessed by more than one users at a time.
    The data is of very cruical nature.

    I am wondering that what table type I shall be using for my database. I am using PHPMyAdmin. I have these choices:

    MyISAM
    HEAP (which is not for such database)
    MEMORY
    MERGE
    MRG:MyISAM
    InnoDB
    INNOBASE

    Thanks in advance


    The second thing that bugs me is that: Is it possible if two users are entering/modifying data at the same time in the same table, they can mess up with the data? I am using SESSIONS that consists of username, IP and time in millisecond.
    Last edited by Oombongo; 01-26-2006 at 05:46 AM.
    "Just smile and wave boys; smile and wave"

  2. #2
    Join Date
    Aug 2005
    Location
    The Garden State
    Posts
    5,634
    The only two engines that are recommended for any use are MyISAM and InnoDB. Their other forms are watered down to give back some speed but not really useful.

    A table should be MyISAM if it needs to take advantage of full text search, or is mostly for querying (maybe data dumping?). Mostly for static tables w/ mass data loads.

    InnoDB is more of a transactional engine, with its row level locking it has faster INSERT/UPDATE/DELETE statements and tables that are heavily modified should take advantage of it.
    Acceptable Use | SQL Forum FAQ | celery is tasteless | twitter

    celery is tasteless - currently needing some UI time

  3. #3
    Join Date
    Dec 2005
    Posts
    55
    Thanks chazzy for the reply (and sorry for my late response as I was away from the city).

    I guess that I will go for the INNODB as it seems to suit my requirements
    "Just smile and wave boys; smile and wave"

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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



Recent Articles