Hello,
I recently created a couple of dll's ( in VB ) which reside on my machine, which is also currently hosting a web site on our intranet.
The dll's have methods which each call a stored procedure in SQL Server and return the records to a web browser. My problem is the performance hit is unbelievable. One of the methods simply grabs a few records ( generally less than 10 ) and populates a list box with them.
Apart from the obvious network traffic issue, is there anything I should know about dll's which makes method access very slow. I have tested the method calls with no one in the building, with the same result.
On my machine ( which has the dll's resident ), the turnaround time is very good. On any other machine it is terrible.
I can provide source if required.
Thanks
Lenin.
