ASP Sites?

They have: 433 posts

Joined: Apr 2000

Hey Peter!

I was wondering if you could list some major sites (like msn.com) which make use of ASPs. My friend who made a MP3 Player program is looking to store users "libraries" (list of songs) within a database and he's wondering if SQL and ASP is the best way to go for speed.

Thanks!
Ravi

------------------
Lyricsh.com
Find the lyrics to over 7,000 Songs.
Lyricsfile.com
Over 20,000 indexed lyric files.

Peter J. Boettcher's picture

They have: 812 posts

Joined: Feb 2000

Ravi,

I don't really have a list of sites that use ASP (besides the ones that I build ). I think it's a given that any site that Microsoft is involved with is going to use ASP, that's just good marketing.

There's many of them out there though, and I think that list will grow as NT Server (Win2K) gets more market penetration into the web server market.

Where you'll find a lot of people using ASP & SQL are on Intranets. Using ASP,SQL, and VB components it's really easy to make powerful browser based applications. But because of browser incompatibilities it makes it hard to bring these applications to the Internet without a lot of reworking.

If you're planning on using NT server then ASP and SQL are definately the best way to go.

Regards,
Peter J. Boettcher

PJ | Are we there yet?
pjboettcher.com

They have: 433 posts

Joined: Apr 2000

what about speed wise? whats the best database solution when you have thousands of users at once?

Rav
PS - did u see lyricsfile.com yet Peter?
------------------
Lyricsh.com
Find the lyrics to over 7,000 Songs.
Lyricsfile.com
Over 20,000 indexed lyric files.

[This message has been edited by Ravi Pachai (edited 30 April 2000).]

They have: 5,633 posts

Joined: Jan 1970

Ravi,

If the site is going to get a far amount of use then go for SQL.

------------------
Adam
AIS Internet Solutions
[email protected]
www.aisinternet.com

Peter J. Boettcher's picture

They have: 812 posts

Joined: Feb 2000

Ravi,

Sorry about that, forgot the speed question. Adam's right, you can feel confident using ASP/SQL 7, it was designed for large applications like you describe.

Just remember when you get into that type of application (thousands of users at once) it sometimes pays to use a COM object to do some common work. So instead of writing a lot of script inside an ASP page, you would just call your COM object, it's a bit more efficient that way. It's just more of a pain to develop since every time you want to make a change you have to recompile and register it on the server again.

I just tried to view www.lyricsfile.com and the site wouldn't come up. If the site is still on Powersurge, then that might explain it, they've been having a lot of problems today.

Regards,
Peter J. Boettcher

PJ | Are we there yet?
pjboettcher.com

They have: 433 posts

Joined: Apr 2000

Thanks Peter and Adam!

What exactly is a COM object? Also I can access lyricsfile.com ok and lyricsh.com, however lyricsfile.com is experiencing some lag. Is it because of the counting in the database? There are almost 20,000 songs, could that be causing the lag?

Thanks,
Ravi

------------------
Lyricsh.com
Find the lyrics to over 7,000 Songs.
Lyricsfile.com
Over 20,000 indexed lyric files.

Peter J. Boettcher's picture

They have: 812 posts

Joined: Feb 2000

Ravi,

A COM object is a piece of code (written in a language like VB, C++, JAVA) that you register on the server to preform tasks that you do frequently or tasks that aren't possible by scripting (system level stuff, impersonating logons, etc).

Then instead of your ASP page handling the scripting or whatever, it passes the values to the COM object for processing. You would only notice the benefits of this if your site was VERY busy.

As to your query lag I'm not sure what the problem is, 20,000 records should not be a problem. I think it has more to do with the fact you're sharing that SQL server with so many people. I'm starting to wonder about how many accounts Powersurge is cramming onto their SQL servers, not to mention their NT servers. I've been finding the DB and web access very slow.

Regards,
Peter J. Boettcher

PJ | Are we there yet?
pjboettcher.com

They have: 433 posts

Joined: Apr 2000

Peter,

Jus wondering if you have anything to say about this email I got from powersurge. Sorry, I know this is going a little off topic, but I chose not to start a whole new thread. Hope you dont mind,

<EMAIL>
The reason for this is that the SQL query on the opening page of
"lyricsfile.com" is huge. When we hit up that page, the SQL server consumes
about 60% of the entire time for both CPUs on the server in question here.
That's why it takes so long to come back to the browser.
</EMAIL>

hmm, could be it be lyricsfile.com.

Thanks,
Ravi

------------------
Lyricsh.com
Find the lyrics to over 7,000 Songs.
Lyricsfile.com
Over 20,000 indexed lyric files.

Peter J. Boettcher's picture

They have: 812 posts

Joined: Feb 2000

Ravi,

So you're the one slowing down the SQL server!!

Why don't you post the SQL/ASP script you're using and I'll see why it's eating up so much CPU. Just make sure to take out the dsn and password stuff, I don't want anyone hacking your db.

Regards,
Peter J. Boettcher

PJ | Are we there yet?
pjboettcher.com

They have: 433 posts

Joined: Apr 2000

It's exactly the one you made for counting the records, its a recordset, then it counts, I'll post it.
<%
Dim SQL
Dim RSArtist
Dim ArtistTotal
Dim RSSongs
Dim SongTotal

Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "DSN=;UID=;PWD="

Set RSArtist = Server.CreateObject("ADODB.Recordset")

SQL = "SELECT * FROM Artist"

RSArtist.Open SQL,Conn,1,3

ArtistTotal = RSArtist.RecordCount

Set RSSongs = Server.CreateObject("ADODB.Recordset")

SQL3 = "SELECT * FROM Songs"

RSSongs.Open SQL3,Conn,1,3

SongTotal = RSSongs.RecordCount

%>

Ravi

------------------
Lyricsh.com
Find the lyrics to over 7,000 Songs.
Lyricsfile.com
Over 20,000 indexed lyric files.

[This message has been edited by Ravi Pachai (edited 05 May 2000).]

Peter J. Boettcher's picture

They have: 812 posts

Joined: Feb 2000

Ravi,

I don't think we need a dynamic cursor for this. Change these lines:

RSArtist.Open SQL,Conn,1,3 to RSArtist.Open SQL,Conn,2,2

and

RSSongs.Open SQL3,Conn,1,3 to RSArtist.Open SQL3,Conn,2,2

And maybe since you're not really retrieving any data from these SQL statements you don't really need to say "SELECT *", change it to just select the primary key like "SELECT ArtistID" & "SELECT SongID".

In the future it might be a good idea to just setup a table that holds this information. So instead of querying the whole database every time, you would just query this table that has the latest totals. You could update this table every day, week or whatever.

Regards,
Peter J. Boettcher

[This message has been edited by Peter J. Boettcher (edited 05 May 2000).]

PJ | Are we there yet?
pjboettcher.com

They have: 433 posts

Joined: Apr 2000

Thanks,

It's not just about making the code, it's about making the code the most effiecent eh.


Ravi

------------------
Lyricsh.com
Find the lyrics to over 7,000 Songs.
Lyricsfile.com
Over 20,000 indexed lyric files.

Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.