asp.net performance

[laziers]

Hi,
Could anyone tell me if is good idee to use asp.net in project such as
"http://www.linkedin.com/"?
I heard that the asp.net "has no good performance" especially using
with mssql.
So, now Im confused.. really I dont believe of this that the asp.net
is slower than jee, ror, php etc.

 

[Jonathan Wood]

I wouldn't believe it either. At least, I'd take a careful look at who was
saying this, and what information they presented to support such a claim.
Unfortunately, from your post, I don't have access to any such information.

 

[Latish Sehgal]

Hi,
Could anyone tell me if is good idee to use asp.net in project such as
"http://www.linkedin.com/"?
I heard that the asp.net "has no good performance" especially using
with mssql.
So, now Im confused.. really I dont believe of this that the asp.net
is slower than jee, ror, php etc.

Hi laziers
Check out http://www.myspace.com/ and http://www.orkut.com/
These are 2 of the biggest social networks out there, both in dot net.
If you follow good coding practices, you should be good. I am myself
working on a small time social networking project using asp.net and
MySQL.
-Latish Sehgal
http://www.dotnetsurfers.com/

 

[Michael Nemtsev [MVP]]

Hello (e-mail address removed),

Who told u that?

Actually it depends on you requirements and the blocking area is only the
bandwidth, but not the SQL Server

I suppose u are not building real-time system with <10ms delays in ASP.net

---
WBR,
Michael Nemtsev [.NET/C# MVP] :: blog: http://spaces.live.com/laflour

"The greatest danger for most of us is not that our aim is too high and we
miss it, but that it is too low and we reach it" (c) Michelangelo


l> Hi,
l> Could anyone tell me if is good idee to use asp.net in project such
l> as
l> "http://www.linkedin.com/"?
l> I heard that the asp.net "has no good performance" especially using
l> with mssql.
l> So, now Im confused.. really I dont believe of this that the asp.net
l> is slower than jee, ror, php etc.

 

[laziers]

Hi laziers
Check outhttp://www.myspace.com/andhttp://www.orkut.com/
These are 2 of the biggest social networks out there, both in dot net.

thats right , meeeen I forgot it

If you follow good coding practices, you should be good.

Im always following

thx for answer.

 

[laziers]

Hello (e-mail address removed),

Who told u that?

hmm... java-guys ?

Actually it depends on you requirements and the blocking area is only the
bandwidth, but not the SQL Server

I suppose u are not building real-time system with <10ms delays in ASP.net

fortunately, I dont

 

[Scott Roberts]

hmm... java-guys ?

Tell the java guys that the *real* programmers over in the asp.net forums
said java is crap and .net is 10X faster.

Seriously, didn't the "language wars" end about 10 years ago? I thought that
today it was chic to be proficient in multiple languages, not a fan-boi of
language "X".

 

[Peter Bromberg [C# MVP]]

Where did you get this FUD info? ASP.NET combined with MS SQL Server is about
the fastest combo around. Big sites will millions of users are written with
these.
-- Peter
Site: http://www.eggheadcafe.com
UnBlog: http://petesbloggerama.blogspot.com
MetaFinder: http://www.blogmetafinder.com

 

[laziers]

Where did you get this FUD info? ASP.NET combined with MS SQL Server is about
the fastest combo around. Big sites will millions of users are written with
these.

hmm asp.net ok is very very fast, but ms sql? :I i saw the tests on
the internet
with mysql, and the mysql was faster :I I know the case of a big site
where developers
wanted to move from php+mysql to asp.net mssql. they do that, they
notice that
the site is much slower :I so they stop migrate to asp.net+mssql.

Hmm in fact this is the reason of my questions and my confuses.

 

[Barrie Wilson]

hmm asp.net ok is very very fast, but ms sql? :I i saw the tests on
the internet
with mysql, and the mysql was faster :I I know the case of a big site
where developers
wanted to move from php+mysql to asp.net mssql. they do that, they
notice that
the site is much slower :I so they stop migrate to asp.net+mssql.

Hmm in fact this is the reason of my questions and my confuses.

The first thing you have to do is evaluate YOUR needs; never mind the
gazillion claims on the internet; I've seen too many of these discussions
go on for days/weeks and it ends up the OP has such nominal requirements
that almost ANY database would have served them well from a performance
perspective.

There are all kinds of published metrics available, depending upon
configuration and use of the DB ... in any case, the general suggestion that
ASP.NET+MSSQL is slow is just plain silly.

That said, if I had 50 PHP developers coding against MySQL on an established
site I don't think I'd even think about making the move you mention unless I
had a long time to transition and get everyone up to speed; there's a
lock-in and training problem, which you should think about if you're
starting from scratch .. what do your people know? who are you going to be
able to hire in your geographic area?

 

[Scott Roberts]

hmm asp.net ok is very very fast, but ms sql? :I i saw the tests on
the internet
with mysql, and the mysql was faster

And here is some guy saying MS SQL is faster:
http://www.devx.com/MicrosoftISV/Article/35028

I'm sure I could look around and find someone "on the internet" who says
"Scott's SQL 2008" is faster.

:I I know the case of a big site
where developers
wanted to move from php+mysql to asp.net mssql. they do that, they
notice that
the site is much slower :I so they stop migrate to asp.net+mssql.

My guess is that the PHP+MySQL developers employed by said company didn't
know enough about .Net and/or SQL Server to make the switch. Or, said
company hired the wrong contractors/developers to make the switch. Or, one
of a billion other reasons......

Let me assure you, your skill as a programmer/DBA will have a much, much
more significant impact on performance than whatever language + DB you
choose.

 

[laziers]

but, I have done some test
1. selecting one record: mysql was faster about 150 ms
2. selecting 50 records: and mysql was faster again :I

 

[Michael Nemtsev [MVP]]

Hello (e-mail address removed),

and how u measured that?

withour production environment settings and FW settings for each platform
u can't compare this results

---
WBR,
Michael Nemtsev [.NET/C# MVP] :: blog: http://spaces.live.com/laflour

"The greatest danger for most of us is not that our aim is too high and we
miss it, but that it is too low and we reach it" (c) Michelangelo


l> but, I have done some test
l> 1. selecting one record: mysql was faster about 150 ms
l> 2. selecting 50 records: and mysql was faster again :

 

[Mark Rae [MVP]]

but, I have done some test
1. selecting one record: mysql was faster about 150 ms
2. selecting 50 records: and mysql was faster again :I

If MySQL works better for you in your environment, use it.

What's the problem...?

 

[laziers]

Hello (e-mail address removed),

and how u measured that?

like this

start = Environment.TickCount;

// Here
sql query in mysql

stop = Environment.TickCount;

star - stop



start = Environment.TickCount;

// Here
sql query in mssql

stop = Environment.TickCount;

star - stop

withour production environment settings and FW settings for each platform
u can't compare this results

ok I see, but it is strange for me why mssql is slower on my machine
than mysql

 

[laziers]

If MySQL works better for you in your environment, use it.

What's the problem...?

Realy? I dont belive that mssql is slower than mysql in spite of
the "my pseudotest" show different result.

hmm.. Now, I realy dont know which database I must choose for the
projeckt like a http://www.linkedin.com/