Results 1 to 3 of 3

Thread: What table type I shall use?

  1. #1
    Join Date
    Dec 2005

    What table type I shall use?


    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:

    HEAP (which is not for such database)

    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 06:46 AM.
    "Just smile and wave boys; smile and wave"

  2. #2
    Join Date
    Aug 2005
    The Garden State
    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
    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