Slow calls to cfdbinfo with MSSQL

[Adam Chapman]

Hi All,

Has anyone experiences horrendously slow calling of cfdbinfo with MSSQL in design mode?

My application regularly times out at 50 seconds.. it seems to get progressively worse during the day if I reboot in the morning.

Hitting the db from the miscellaneous directory (bypassing the ORM) gives me no such grief.

Some more info below.. I notice there are 2 open locks.. could there be some sort of race condition?

Regards,

Adam

Total Time Avg Time Count Template

192514 ms 9625 ms 20 C:\www\myapp\wheels\model\adapters\SQLServer.cfc$$getColumns

Lucee 4.5.2.017 Error (expression)

Message request (path: C:\www\myapp\rewrite.cfm (C:\www\myapp\wheels\global\cfml.cfm):1) has run into a timeout (50 seconds) and has been stopped. open locks at this time (reloadlock3575e1851be908bc7f50ee26a55dfd9a, modellock3575e1851be908bc7f50ee26a55dfd9a).

Stacktrace The Error Occurred in

C:\www\myapp\wheels\global\cfml.cfm: line 192

    190: <cfset StructDelete(arguments, "password")>

    191: </cfif>

    192: <cfdbinfo attributeCollection="#arguments#">

    193: <cfreturn loc.rv>

    194: </cffunction>

[Per Djurner]

Yes, race conditions can occur when running in Design mode.

I think the long term plan is to get rid of that environment mode completely and document that it's best to run in Development mode and do a reload request after any changes to the database or "init" code.

--
You received this message because you are subscribed to the Google Groups "CFWheels" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cfwheels+u...@googlegroups.com.
To post to this group, send email to cfwh...@googlegroups.com.
Visit this group at http://groups.google.com/group/cfwheels.
For more options, visit https://groups.google.com/d/optout.

[Adam Chapman]

I'll give development mode a whirl.. Thanks Per..

You received this message because you are subscribed to a topic in the Google Groups "CFWheels" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/cfwheels/BMrjw6LO_wk/unsubscribe.
To unsubscribe from this group and all its topics, send an email to cfwheels+u...@googlegroups.com.

[Andy Bellenie]

Hmm odd.

What happens if you just run <cfdbinfo> with hard coded arguments in a controller? If that works fine, I'd dump out the arguments scope used above and see which argument is causing the problem.  

--