Coldfusion and SQL 2008 running slow?

[turbo79]

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

[Guest]

Are you using the developer edition of ColdFusion?

[turbo79]

yes, using the developer version of coldfusion 8.

[Adam Cameron.]

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

[turbo79]

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

Thanks

[Guest]

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.

[Adam Cameron.]

You beat me to it!

I'd just start with looking at the debug output... that gives the times of the template executions and all the queries.  Look for anomalies there.

It also sounds like the OP could benefit from reading this section of the docs - http://livedocs.adobe.com/coldfusion/8/htmldocs/Debug_01.html - before doing anything.

--

Adam

[turbo79]

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

>server.

Workstation and server are on the same LAN - trace route shows <1 mS

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

Coldfusion appears to be serving up the page in approx 16 mS when accessed from the server and/or from the workstation.

----------------------------------------------

Execution Time

Total Time Avg Time Count Template
0 ms 0 ms 1  C:\ColdFusion8\wwwroot\admin8\index.cfm
16 ms   STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
16 ms   TOTAL EXECUTION TIME
red = over 250 ms average execution time

----------------------------------------------

But the delay when accessing the webpage from a workstation is still about 10 seconds.

>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?

One thing's for sure, it doesn't have anything to do with the SQL Server.  The delay is on every page - including ones that have no queries.  I'm beginning to wonder if the delay is in getting the connection to the web server. I'm using the webserver that comes with coldfusion 8 (developer).  Are there any known caveats when working with that webserver?

I've got an XP Pro server, maybe I'll try using their webserver instead...

Thanks,

Robert

[turbo79]

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

Robert