I didn't find anything in the search about this but just wondering if php/mysql is a good solution to bigger databases such as millions of rows of data?
how does it fair compared to asp/sql?
minor performance/security or major do you think?
PHP/MYSQL vs. ASP/SQL
Moderator: General Moderators
the problem with mysql isn't a lack of performance or speed - in fact, it's one of the fasted DBs. It achieves this speed, though, because it lacks many advanced features of more advanced DBs like Postgres or Oracle. (Subselects, view, and some others). It can scale up to very large size (more on linux, i believe, than windows).
So in short, it's good on performance and security (and ease of install/use) but not so good on features.
PS. sql is a language (structured query language) not a database manager. You probably mean Microsoft SQL server, a name they (IMHO) took to make it seem as if they are SQL, which is untrue.
So in short, it's good on performance and security (and ease of install/use) but not so good on features.
PS. sql is a language (structured query language) not a database manager. You probably mean Microsoft SQL server, a name they (IMHO) took to make it seem as if they are SQL, which is untrue.