Dev Shed Forums

**scar65**

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

freebsd

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.

philip

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 :
http://www.mysql.com/documentation/m...sing_functions

btw, transactions are not available by choice (read from above link) and sub-selects are on there way (read todo list)
http://www.mysql.com/documentation/m...p?section=TODO

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, ...

Dev Shed Forums

Thread: What are MySQL's Limitations

Similar Threads

Oracle to ASP.NET limitations

Password limitations in the .htpasswd file

unique id from mysql's built-in functions?

Safe Mode limitations?

MySQL's password() function