| # |
Sep 21st 2011, 13:48 |
dakota |
Section58: you know, just something to look at for the future :) |
| # |
Sep 21st 2011, 13:48 |
dakota |
Section58: For you filtering, I'm going to point you back to my original suggestion. The CakeDC search plugin is fantastic for anything involving searching. It makes it incredibly easy to build up complex filters |
| # |
Sep 21st 2011, 13:48 |
carichardson |
Do any of you use database sessions in cake? |
| # |
Sep 21st 2011, 13:47 |
dakota |
~ad7six-advice |
| # |
Sep 21st 2011, 13:47 |
dakota |
Section58: Something that helps me tremendously when writing complex queries is to first write out the manual sql query in phpmyadmin (or whatever) and only then convert it to 'cake style' |
| # |
Sep 21st 2011, 13:47 |
Section58 |
why do they have to make it so complicated :( |
| # |
Sep 21st 2011, 13:47 |
Section58 |
if the query just grabs events then it would be one line |
| # |
Sep 21st 2011, 13:46 |
Section58 |
i think the orignal filtering is putting it off |
| # |
Sep 21st 2011, 13:46 |
dakota |
but you could do it with joins. |
| # |
Sep 21st 2011, 13:46 |
dakota |
containable is basically an intellegent wrapper around $recursive |
| # |
Sep 21st 2011, 13:46 |
dakota |
recursion would give you the same result |
| # |
Sep 21st 2011, 13:45 |
Section58 |
and not use contains |
| # |
Sep 21st 2011, 13:45 |
Section58 |
so maybe i can use recurtion and joins |
| # |
Sep 21st 2011, 13:45 |
dakota |
that is true |
| # |
Sep 21st 2011, 13:45 |
Section58 |
well normally i have found there are many ways to do the same thing in php |
| # |
Sep 21st 2011, 13:45 |
dakota |
) |
| # |
Sep 21st 2011, 13:45 |
dakota |
~premature |
| # |
Sep 21st 2011, 13:45 |
dakota |
~linkable |
| # |
Sep 21st 2011, 13:45 |
dakota |
You could maybe look at linkable, but I'm not sure if it will work like you want. Plus, I've never used it |
| # |
Sep 21st 2011, 13:44 |
Section58 |
in my attempt to keep querys down, i apear to have made them worse |
| # |
Sep 21st 2011, 13:44 |
dakota |
Section58: yeah |
| # |
Sep 21st 2011, 13:44 |
Section58 |
where it should be just 5 |
| # |
Sep 21st 2011, 13:44 |
Section58 |
well logically it will do that 1 time for each event matching an artist, cause here is 5 artists in that call, thats 25 lines of sql |
| # |
Sep 21st 2011, 13:44 |
dakota |
anyways, to directly answer your question, you'd need to switch to using joins/hasOne binds |
| # |
Sep 21st 2011, 13:43 |
dakota |
small times |
| # |
Sep 21st 2011, 13:43 |
dakota |
Doesn't look that bad |
| # |
Sep 21st 2011, 13:43 |
Section58 |
cause its not so awesome for perforance |
| # |
Sep 21st 2011, 13:43 |
Section58 |
how do i go about tidying that up |
| # |
Sep 21st 2011, 13:43 |
dakota |
unfortunately |
| # |
Sep 21st 2011, 13:43 |
dakota |
Section58: you can't really. It's just how containable works |
| # |
Sep 21st 2011, 13:43 |
Section58 |
yeah er, 'if containable looks like that' |
| # |
Sep 21st 2011, 13:42 |
dakota |
Section58: no, I seriously thought you were refering to the appearance of the sql dump, rather than the queries |
| # |
Sep 21st 2011, 13:42 |
Section58 |
are you guys going to double team me again |
| # |
Sep 21st 2011, 13:42 |
Section58 |
cayse those querys are not needed |
| # |
Sep 21st 2011, 13:42 |
dakota |
Section58: by 'this' I thought you were referring to the sql dump :) |
| # |
Sep 21st 2011, 13:41 |
Section58 |
ok, so, how can i stop contain from being so active? |
| # |
Sep 21st 2011, 13:41 |
Section58 |
then i wouldn't beable to see it haha |
| # |
Sep 21st 2011, 13:41 |
dogmatic69 |
Section58: that is not repeating, that is containable in action |
| # |
Sep 21st 2011, 13:41 |
dakota |
Section58: remove $this->element('sql_dump'); from your layout |
| # |
Sep 21st 2011, 13:40 |
franki |
thanks |
| # |
Sep 21st 2011, 13:40 |
dakota |
~tell franki about debugKit |