September 30th, 2000, 02:52 PM
-
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
September 30th, 2000, 03:44 PM
-
October 2nd, 2000, 12:13 PM
-
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, ...