DripStat - most time consumed sp_tables, sp_fkeys, sp_columns, sp_pkeys. Optimization possible?

[Thorsten Eilers]

Hi,

I installed dripstat.com to monitor lucee/tomcat.

The SQL shows
sp_tables, sp_fkeys, sp_columns, sp_pkeys
are in the top 10 fo most time consuming queries.

I guess cfwheels uses these stored procedures for its ORM?

Is this correct and do you think there is any value in trying to optimize this part?

Thorsten

[Per Djurner]

What database is that on?

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

[Thorsten Eilers]

MS SQL 2012

[Per Djurner]

Does it run sp_columns, for example, often?

I'm asking because when running in production mode it should only run that once per model in your application (through cfdbinfo).

On Saturday, September 12, 2015, Thorsten Eilers <thorste...@googlemail.com> wrote:

MS SQL 2012

[Thorsten Eilers]

Hi Per, I will let it log a few days to see if it makes a difference.

[Risto]

Try running one of the stored procedure directly on your sql server and compare the time versus what your monitor shows for the time when cfwheels executes it. If the cfwheels time is much longer than when you execute it on the sql server then there is probably something that could be optimized. If not, then it sounds like the cfwheels way of executing once per model in production mode is a good approach.