Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Server.CreateObject vs CreateObject

1 view
Skip to first unread message

Egbert Nierop

unread,
Dec 30, 1999, 3:00:00 AM12/30/99
to
The old issue with NT 4 and iIS4 was use CreateObject for performance
reasons if you don't need transactions in ASP

Currently I have tests proving that Server.CreateObject is 2x faster than
CreateObject

Do Until Timer - T > 1
x = x + 1
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "provider=sqloledb;initial catalog=pubs;data source=EG2;user
id=sa;password=;"
Conn.Close
Set Conn = Nothing
Loop


benchresult: Server.CreateObject in 1400 times / sec
CreateObject: 820 times/sec

WHat could be the reason that Server.Createobject is faster now?

Regards,

Egbert

John Leggett

unread,
Jan 8, 2000, 3:00:00 AM1/8/00
to
Fewer RFC in IIS5.

"Egbert Nierop" <e.ni...@spammeandIspamyoubetter.com> wrote in message
news:OptEnBtU$GA....@cppssbbsa02.microsoft.com...

Egbert Nierop

unread,
Jan 16, 2000, 3:00:00 AM1/16/00
to
Thanks
b.t.w. what is RFC? Request for change/command?

"John Leggett" <legg...@pacbell.net> wrote in message
news:e$QrhlhW$GA.260@cppssbbsa04...

Mike Amundsen

unread,
Jan 28, 2000, 3:00:00 AM1/28/00
to
I suspect RFC shuld have been RPC (remote procedure calls)

Under NT, we found that createobject in ASP pages could screw up the MTS
process, too. We've been doing server.createobject ever since.

MCA

"Egbert Nierop" <e.ni...@nospam.net> wrote in message
news:eGhOzhFY$GA.255@cppssbbsa05...

James Talbut

unread,
Jan 31, 2000, 3:00:00 AM1/31/00
to

"Egbert Nierop" <e.ni...@spammeandIspamyoubetter.com> wrote in message
news:OptEnBtU$GA....@cppssbbsa02.microsoft.com...
> Do Until Timer - T > 1
> x = x + 1
> Set Conn = Server.CreateObject("ADODB.Connection")
> Conn.Open "provider=sqloledb;initial catalog=pubs;data source=EG2;user
> id=sa;password=;"
> Conn.Close
> Set Conn = Nothing
> Loop

Given that the connection object could be pooled I'd suggest that this is an
unfair test (though I'm not commenting on the results).
I'd try running it with a VB object to ensure that it isn't being pooled.

J.T.

0 new messages