WFC
asked on
Linux/PHP vs. ASP
We are about to start a project which will enable users to query a
database and which will return results and record their queries. The
table being queried on will have about 10,000 records, and each query
will write one record to another table (we expect to eventually get
200-500 queries a day, so that table would eventually have in the
neighborhood of 100,000 records. We are trying to decide what
configuration to use, and have narrowed it down to Linux/PHP/MySQL vs
ASP/MSSQL. Any opinions? Should we be concerned about the lack of
scalability of MySQL?
Also is there a difference in performance between PHP and ASP?
We're just getting started, so any info/tips
would be greatly appreciated.
database and which will return results and record their queries. The
table being queried on will have about 10,000 records, and each query
will write one record to another table (we expect to eventually get
200-500 queries a day, so that table would eventually have in the
neighborhood of 100,000 records. We are trying to decide what
configuration to use, and have narrowed it down to Linux/PHP/MySQL vs
ASP/MSSQL. Any opinions? Should we be concerned about the lack of
scalability of MySQL?
Also is there a difference in performance between PHP and ASP?
We're just getting started, so any info/tips
would be greatly appreciated.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I would highly suggest you look at .NET. We have experiences serious speed improvements with it...something like 3 times faster than classic ASP. Also, the development time is MUCH shorter than either ASP or PHP. I think are on the right track with MSSQL as well.
my personal choice would either be MySQL & JSP or .NET & sql server. purely for the modularity of both combinations, it sounds like there is a need to future proof the site and any attempts to make the site easilly maintainable will help. storing the functionallity in javabeans aids this. i lack experience with .NET but i am informed and assured of its scaleable and robust capabilities. where does your in-house expertise lay? this should probably weigh your decision. maybe check this site out, i know its not aspx but it is definatly in the same district...
<a>href="http://www.greenside.demon.co.uk/home/mark/experience.html">asp experience</a>
<a>href="http://www.pointafter.com/Archives/nl0203.htm">another site</a>
hope this helps...
<a>href="http://www.greenside.demon.co.uk/home/mark/experience.html">asp experience</a>
<a>href="http://www.pointafter.com/Archives/nl0203.htm">another site</a>
hope this helps...
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
What happened to all the real programers? ASP.NET faster that what an Elephant? yes that I will beleive, but you cant run ASP.NET on any platforms other than Windows, Which is your first problem, Microsoft has'nt figured out how to wirte an OS yet and you think they can write a decent development suite? I though that slammer worm would teach everybody a lesson about Microsoft's suckiness, but I guess there are still some suckers out there.....
Microsoft O/S will never be as fast or as reliable as UNIX/Linux based O/S. O ya at 200-500 quieries a day,,, Nothing Nothing Nothing Nothing, There is no microsoft DB that can handle 100'000's to millions of hits daily, unless the servers got a 2 billion Mhz CPU with a gillion megs of RAM
Anyway, sorry for the rambling message I guess this is what 8 beers and a hatred for Micromonkeys will get me,,,
Microsoft O/S will never be as fast or as reliable as UNIX/Linux based O/S. O ya at 200-500 quieries a day,,, Nothing Nothing Nothing Nothing, There is no microsoft DB that can handle 100'000's to millions of hits daily, unless the servers got a 2 billion Mhz CPU with a gillion megs of RAM
Anyway, sorry for the rambling message I guess this is what 8 beers and a hatred for Micromonkeys will get me,,,
I am a PHP/MySQL developer and here is why...
1) It runs on most platforms
2) It performs very well, I have never had a problem with it.
3) IT IS FREE!!! (opensource)
4) Large community backing it with solutions, again for free
5) widely available
6) I don't need to drink 8 beers to loosen my lips with respect to hating microcrap
7) the learning curve isn't particularly hard.
The performance requirements that you are asking for are quite negligible and could ver easily be handled by PHP/MySQL.
Hope this helps
frankenstrat
1) It runs on most platforms
2) It performs very well, I have never had a problem with it.
3) IT IS FREE!!! (opensource)
4) Large community backing it with solutions, again for free
5) widely available
6) I don't need to drink 8 beers to loosen my lips with respect to hating microcrap
7) the learning curve isn't particularly hard.
The performance requirements that you are asking for are quite negligible and could ver easily be handled by PHP/MySQL.
Hope this helps
frankenstrat
This question has been classified abandoned. I will make a recommendation to the
moderators on its resolution in a week or two. I appreciate any comments
that would help me to make a recommendation.
<note>
Unless it is clear to me that the question has been answered I will recommend delete. It is possible that a Grade less than A will be given if no expert makes a case for an A grade. It is assumed that any participant not responding to this request is no longer interested in its final disposition.
</note>
If the user does not know how to close the question, the options are here:
https://www.experts-exchange.com/help/closing.jsp
Cd&
moderators on its resolution in a week or two. I appreciate any comments
that would help me to make a recommendation.
<note>
Unless it is clear to me that the question has been answered I will recommend delete. It is possible that a Grade less than A will be given if no expert makes a case for an A grade. It is assumed that any participant not responding to this request is no longer interested in its final disposition.
</note>
If the user does not know how to close the question, the options are here:
https://www.experts-exchange.com/help/closing.jsp
Cd&
Don't really care how this one turns out...
gator4life
(chomp, chomp)
gator4life
(chomp, chomp)
I agree with gator - hard to say if any answer really helped WFC as he never answered.
points split
COBOLdinosaur
PE Web Development
COBOLdinosaur
PE Web Development