How can I eliminate CakePHP's "SHOW FULL COLUMNS" queries? - McMap

About

How can I eliminate CakePHP's "SHOW FULL COLUMNS" queries?

Asked 15/3, 2011 at 15:9 Answered 15/3, 2011 at 15:22

Solved php mysql cakephp cakephp-model

C

1

6

I realize that these might not necessarily be a huge performance issue, but I'd like to get rid of any unnecessary SHOW FULL COLUMNS FROM queries that Cake generates. I've tried using the Containable behavior, which I thought would stop Cake from looking at any associations that I haven't included in my find(), but I still see the SHOW FULL COLUMNS FROM queries in my SQL dump. I have also tried unbindModel(), but it has no effect.

I'm not an expert, and don't understand all the intricacies of Cake, so any help here would be greatly appreciated!

Cheat answered 15/3, 2011 at 15:9 Comment(0)

R

5

Doesn't it cache it when the debug level is set to 0?

Repartee answered 15/3, 2011 at 15:22 Comment(3)

Yup, looks like Cake only uses these queries for debugging purposes and therefore, it goes away when debug is set to 0. Thanks! – Cheat 15/3, 2011 at 15:29

Sorry for hijacking; but WHY does Cake do this? – Silk 15/4, 2011 at 12:36

I have the same problem, although the debug mode is 0, is there anything else that needs to be set? – Sholokhov 19/5, 2014 at 8:28

Recommended topics

#Godot #Unity #Godot 4.X #Mongodb

Hot tags

Godot Unity Godot Help Programming Godot 4.X GUI GDScript 3D 2D Physics CSharp Godot 3.X VR XR Projects C++

© 2022 - 2024 — McMap. All rights reserved.