1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2000
    Rep Power
    I am trying to decide on the technichal architecture for a website I am building. I like mySQL but the developer does'nt. How accurate are these statements?

    MySQL does not support transactions.
    MYSQL does not support sub-selects.
    There is a lack of long-term stability.
    Does not support heavy loads (???)

    Please help! They are also dumping on PHP4
  2. #2
  3. No Profile Picture
    Devshed Newbie (0 - 499 posts)
    Check this out -> http://www.phpbuilder.com/columns/ti...05.php3?page=1

    >>They are also dumping on PHP4

    Maybe because PHP (as an Apache module) is very insecure on a shared server.
  4. #3
  5. No Profile Picture
    Devshed Newbie (0 - 499 posts)
    well, what database and scripting environment are they proposing? everything has its ups and downs, pros and cons, goods and bads, high points and low points, do's and don'ts ... it's easy to put something down and find faults as nothing is perfect and nothing is perfect for every job/need/desire. nothing. re: mysql, not sure about 'lack of long-term stability' and 'does not support heavy loads' as that is an opinion and imho is false but re: sub-selects and transactions read this :

    btw, transactions are not available by choice (read from above link) and sub-selects are on there way (read todo list)

    good luck btw, postresql has transactions available if so desired which makes it slower but rather then start a sql war here ... it's all about personal preference, give and take, win some you lose some, choose your battles, ...

Similar Threads

  1. Oracle to ASP.NET limitations
    By mpgalvin in forum Oracle Development
    Replies: 0
    Last Post: February 5th, 2004, 03:40 AM
  2. Password limitations in the .htpasswd file
    By yashi in forum Apache Development
    Replies: 1
    Last Post: November 13th, 2003, 12:25 AM
  3. unique id from mysql's built-in functions?
    By neobuddah in forum MySQL Help
    Replies: 0
    Last Post: May 2nd, 2003, 04:25 AM
  4. Safe Mode limitations?
    By dreamstring in forum PHP Development
    Replies: 0
    Last Post: January 22nd, 2003, 06:54 AM
  5. MySQL's password() function
    By IrinaIonela in forum PHP Development
    Replies: 2
    Last Post: February 14th, 2002, 07:10 PM

IMN logo majestic logo threadwatch logo seochat tools logo