Coldfusion and SQL 2008 running slow?

Forum|Forum|16 years ago
February 25, 2010
3 replies
1373 views

I built an app using coldfusion and the developer version of sql 2008. When I browse the pages while logged into the server (that is running coldfusion and sql 2008), it works great - very fast. However, when I browse the pages from a client machine (connected to the same lan), it runs extremely slow - as in it takes between 5 and 10 seconds to load every single page. I captured some of the packets via the firewall. It looks like it may be timing out on a dns lookup. I'm using the ip address in the browser, so not sure why it would do a lookup. Any thoughts on what I might try to speed things up?

Thanks,

Robert

Database access

This topic has been closed for replies.

T

turbo79Author

Participant

migrating to MS IIS made the problem go away. Thanks for the tips!

Robert

A

Adam Cameron.

Inspiring

Is the delay in getting an initial connection to the web server, or between the web server and CF, or is it some part of the code taking longer or what?

--

Adam

T

turbo79Author

Participant

any tips on how to go about finding the answers to A. Cameron's questions?

Thanks

A

Anonymous

Well, tracert might give you info on if its taking a long time to reach the web server.

GetTickCount() can be used before and after the queries, and the resulting difference can be displayed on your final output.

You can turn on debugging output and make sure it's showing all the details.

Get your hands on SeeFusion or FusionReactor to benchmark your pages as they run.

hth,

D.

A

Anonymous

Are you using the developer edition of ColdFusion?

T

turbo79Author

Participant

yes, using the developer version of coldfusion 8.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded