whats better.. asp with COM OR php???

[deadeye]

hello fellow programers,

i am hoping to make a large e-commerce community. Now my main problem is fondation questions.

What are the pro's and cons of using
- php with sql
- asp with a vb COM object accessing sql.

i require speed and stability.

and qhat is the diffrence between sql and mysql????

any feedback whould be most apreashiated..

thank you for your time and help.

[pactalon]

First of all, you'll never get anywhere without taking a spelling lesson.

PHP Pro's:

- Typically more stable;
- Typically faster; and
- Runs on Linux etc. servers, which are generally cheaper.

ASP Pro's:

- Much easier to write (especially with dev tools);
- Database connections are easier with ADO;
- Can take advantage of Windows 2000 Server and IIS 5.0, which come with really jazzy server features; and
- Better for larger sites handling complex data transactions.

[deadeye]

i rote that in a hurry (umm like this one) hehaehahe

so is a compiled COM object slower then php???

and what dev tools are you talking about? (ive never used them or have and not known)

also what is the diffrence between sql and mysql if any?

thanks again

[pactalon]

Speed depends on what your scripts are doing, and how well you've programmed them, as well as your system hardware. The faster the system you're talking about, the greater chance there is Windows 2000 better handling those accelerated resources.

Perhaps the most popular development tools for building server side applications are Microsoft Visual BASIC and Visual InterDev, both available at:

http://msdn.microsoft.com/vstudio/

The difference between MySQL and Microsoft SQL Server are numerous. Check out their Web sites at:

http://www.mysql.com and
http://www.microsoft.com/sql

Hope this helps!

[parksie]

The major difference is that MySQL and PHP are open-source. This means that any bugs are likely to be fixed much more quickly - the provider who runs the servers will be keeping an eye on the updated versions.

[pactalon]

Not only is bug fixing the benefit of open source, but also h4x0ring -- remember, open source goes both to the developer and to your competitor's "IT" team.

[parksie]

Yeah, but you can't stop someone using specific software

[pactalon]

See, when one encloses IT in quotations (like this, "IT" team), it means that it's less like information-technology and more like sabotage. Now you've ruined the whole thing. Thnaks a lot.

[deadeye]

thanks for your help.

[parksie]

Originally posted by pactalon
See, when one encloses IT in quotations (like this, "IT" team), it means that it's less like information-technology and more like sabotage. Now you've ruined the whole thing. Thnaks a lot.

Just so I don't jump to any conclusions...could you clarify that, please?

[pactalon]

Argh. When you have source code that is available to everyone, it makes it much easier for h4x0rz (like Jeff K.) to get in and take down your machine.

[parksie]

Yes, but for most open source software, people with good intentions usually find the security flaws as well, and point them out and/or fix them.

You're right that if your competitors really wanted to, they could use flaws in the code - your point is proven by all the recent "script kiddies" attacks.

But, the important thing is that most of the breaches have now been fixed, and much faster than the large corporations can react.

[pactalon]

And anyone can report a "security hole" and create a patch for it. If it were a severe security hole, everyone would download and install it. Seems to me like a great way to spread a virus...

OTOH, if Microsoft releases a security patch for, say, IIS 5.0, then we can be sure that this isn't a malicious virus (of course, all of the l33t l1nucks lusers are going to flame me for this...)

[parksie]

Then I'll flame ya Not really - although I do use Linux.

With open source software - you'd have to give the source or noone would download it! So any viruses spread would be a bit useless.

[pactalon]

Perhaps not a readily-visible virus. Or maybe a patch doing just the opposite -- compromising security to assist another program.

[parksie]

My point still stands - the developers responsible for the program's integrity would notice what the code was doing, and not implement it!

[pactalon]

So it's impossible to hide a virus or backdoor or trojan or something of that sort from even the newest of users?

[pactalon]

But we're not talking about a "developer" here, we're talking about a l33t h4x0r.

[deadeye]

**** it is amusing listening to this..

haehaehhaeha

[ac11965]

what is the difference between java and asp?
and which one is easier to use?

[parksie]

Java is a language, ASP is a technology

You can use Java within an ASP, but it's usually used in a JSP. Basically, they're pretty similar - code embedded in the HTML.