Results 1 to 2 of 2

Thread: what taype type to use?

  1. #1
    Join Date
    Jan 2006
    Posts
    1

    what taype type to 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.

  2. #2
    Join Date
    Jan 2006
    Posts
    6
    Stick with MyISAM unless you know what you're doing.

    MySQL is designed to handle millions of queries per second. You will not have problems with two or three people updating the database at once.

    Now, if you are both editing the same row in phpMyAdmin, you could easily overwrite each other's work, but that's not really a database issue.

Posting Permissions

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