 -boRg- wrote:
No as it's more than just the sub quiries that are the problem, ASP doesn't talk to an mySQL database very well using ODBC as the myODBC drivers is not very good and so you loose quite a number of features. |
I use MySQL with both Classic ASP and ASP.NET daily as a proffessional WebDeveloper, so that is BULL.
-boRg- wrote:
To make the forum work with mySQL would require that 99% of the pages to be re-written, loosing performance and security from the forum, so I would rather concetrate on Access and SQL server which are used more often with ASP.
|
In my opinion, Recordset.AddNew, should almost NEVER been used due to negative performence issues (more overhead with .AddNew than with regular INSERT, UPDATE and DELETE in straight SQL-queris)
Security? what are You talking about ..... You have more security with a MySQL database than an Access ....
IF! you had avoid that in code (.AddNew), the conversion to mySQL should be as easy as add another if-statement to runt against mySQL instead of MS-SQL or Access and some queries where dates are involved.
just my €0.02
/PatrikB
Edited by The WizeGuy
WebWiz i MySQL4
Topic Options
price 
