PHP/MYSQL vs. ASP/SQL

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
JPlush76
Forum Regular
Posts: 819
Joined: Thu Aug 01, 2002 5:42 pm
Location: Los Angeles, CA
Contact:

PHP/MYSQL vs. ASP/SQL

Post 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?
User avatar
llimllib
Moderator
Posts: 466
Joined: Mon Jul 01, 2002 2:19 pm
Location: Baltimore, MD

Post 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.
JPlush76
Forum Regular
Posts: 819
Joined: Thu Aug 01, 2002 5:42 pm
Location: Los Angeles, CA
Contact:

Post by JPlush76 »

yep microsoft SQL server

so can you make up for those features in clever php programming?
User avatar
llimllib
Moderator
Posts: 466
Joined: Mon Jul 01, 2002 2:19 pm
Location: Baltimore, MD

Post 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.
JPlush76
Forum Regular
Posts: 819
Joined: Thu Aug 01, 2002 5:42 pm
Location: Los Angeles, CA
Contact:

Post by JPlush76 »

gotcha :)
Post Reply