Page 1 of 1
PHP/MYSQL vs. ASP/SQL
Posted: Thu Aug 15, 2002 9:50 pm
by JPlush76
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?
Posted: Thu Aug 15, 2002 10:04 pm
by llimllib
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.
Posted: Thu Aug 15, 2002 10:06 pm
by JPlush76
yep microsoft SQL server
so can you make up for those features in clever php programming?
Posted: Thu Aug 15, 2002 10:12 pm
by llimllib
depends on what you're doing. If you're going to need a lot of subselects or views, it'll save you lots of trouble to use Postgres. If not, if you're just doing simple inserts/updates/selects, then mysql is the easiest. You need to pick the right tool for the job.
Posted: Fri Aug 16, 2002 6:23 pm
by JPlush76
gotcha
