ISAPI Dll and DataSnap - Performance question


2005-12-12 01:57:34 PM
off-topic18
Hi guys, a general question.
I have been using for DataSnap and ISAPIs dll for a while.
The application we work on, needs to be extremly efficient. So i have a
question regarding performance.
Right now everytime i receive a request on the ISAPI and a query is
performed on datasnap (running on MTS Transaction Modules), on the response
event, i close the DCOM connection.
Now, it works well, but i'm wondering if i will get a better performance if
i dont close the DCOM connection. I need my ISAPI to be fully stateless due
to load balancing peformed using the DataSnap load balancer, so i assume
that the best way to make sure thats the case was by closing the DCOM
connection.
On the LAN side i don't close the DCOM connection, so i have both scenarios,
and i can't tell which one gives me the best performance. I imagine that
not closing the connection is the right thing to do, because creating the
connection context etc, may take some time, but, im afraid that by doing
that i may be loosing some of my stateless requirement on the webservers.
To Craig, Dan, Bob or any of the DataSnap gorus out there, a word of wisdom
will be great for me.
Thanks in advance.
Esteban Pacheco
A Delphi Programming Blog
estebanp.blogspot.com
www.epachsoft.com