EasyCFM.COM ColdFusion Forums / MS SQL Server Related Issues / SQL Server connection very slow from CF

   Reply to Discussion | New Discussion << previous || next >> 
Posted By Discussion Topic: SQL Server connection very slow from CF

book mark this topic Printer-friendly Version  send this discussion to a friend  new posts last

sebumd
02-28-2009 @ 10:52 PM
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
New Member
Posts: 1
Joined: Feb 2009

We have a web server on the same lan as the DB server.

A simple select * from tablename (~100 entries) is
taking anywhere from 30ms to 10 seconds lan. ASP code
on the web server provides instant (30ms) queries. Ping
is never <1ms. If I point to a remote DB server, the
same query is never more than 300ms (which is great for
over the internet).

I enabled logging in CFAdmin -> Datasources and shortly
after my select * from tablename I see this:

spy(2009/02/28 16:39:00.539)>>
Connection[2].setReadOnly(boolean readOnly)
spy(2009/02/28 16:39:00.539)>> readOnly = false
spy(2009/02/28 16:39:00.539)>> OK
spy(2009/02/28 16:39:05.726)>> OK (true)

We need to get this up and running ASAP. Please help!!


Website Designed and Developed by Pablo Varando.