Roji Thomas wrote:
> Using a COM over ASP code for data access
> gives performance gain on an IIS 5.0, MTS
> and SQL server platform?
>
> we are having a debate on it.
> Like to know what u masters think and
> also point me to some URL with info abt it
the ADO objects ARE com objects, you will only get a REAL performance
gain, if you have to do a lot of preprocessing, or formatting before
display... otherwise, using the ado objects directly in asp will usually
work best, except under extremely heavy load, in which case a faster
server, or cluster may be a better option anyway.
DB <-> Business/DB Object(s) <-> Formatting Objects (for ASP) <-> ASP Code
this is one way, for more complex sites, breaking things up like this will
usually yeild the best results. an object set strictly for business logic
and db access, that isn't asp specific, that can be used for other apps.
in front of that, if you do have complex formatting needs, using another
object layer for your html formatting, in a separate object is best.
then the asp for simple processing... if you don't have complex needs or
a large operation... DB <-> ASP Code (w/ ADO) ..may be your best choice.
--
-----------------------------------------------------------------------
Michael J. Ryan | ICQ: 4935386
tracker1(at)theroughnecks(dot)com | AIM/AOL: azTracker1
Roughneck BBS: | Yahoo: azTracker1
http://www.theroughnecks.net | MSN: (email address)
telnet://theroughnecks.net | Trillian: www.trillian.cc
---
You are currently subscribed to activeserverpages as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
