| # |
Jan 30th 2014, 20:46 |
fnfilho |
still... the entire coments table by itself has around 4gb, the simple select limit 1 is still very slow with the server and version i'm running :/ |
| # |
Jan 30th 2014, 20:46 |
BackEndCoder |
Fatalnix, cake 1.2 ? |
| # |
Jan 30th 2014, 20:45 |
Fatalnix |
2008* |
| # |
Jan 30th 2014, 20:45 |
Fatalnix |
Well that doesn't seem to do anything. This is from 2009 too, so I imagine it has probably changed. |
| # |
Jan 30th 2014, 20:44 |
BackEndCoder |
and make your comments paginated |
| # |
Jan 30th 2014, 20:44 |
BackEndCoder |
just use one of them |
| # |
Jan 30th 2014, 20:44 |
BackEndCoder |
i think you should make the comments table big still |
| # |
Jan 30th 2014, 20:44 |
BackEndCoder |
you will still crash |
| # |
Jan 30th 2014, 20:44 |
BackEndCoder |
well the thing is... if its still looking thu all them tables for the output |
| # |
Jan 30th 2014, 20:44 |
fnfilho |
todds, yeah... thats actually a way out |
| # |
Jan 30th 2014, 20:43 |
fnfilho |
noway to do it with finderQuery? |
| # |
Jan 30th 2014, 20:43 |
todds |
fnfilho: you can leave the association and just set recursive = -1 when you don't require the associated records |
| # |
Jan 30th 2014, 20:43 |
Fatalnix |
yeah working with it now |
| # |
Jan 30th 2014, 20:43 |
BackEndCoder |
it sounds close |
| # |
Jan 30th 2014, 20:43 |
BackEndCoder |
Fatalnix, try it |
| # |
Jan 30th 2014, 20:43 |
Fatalnix |
I found on some mailing list |
| # |
Jan 30th 2014, 20:43 |
BackEndCoder |
pagination? only in a custom pagination class maybe |
| # |
Jan 30th 2014, 20:42 |
Fatalnix |
BackEndCoder: yeah I just looked an theres some documentation on setting $name in the controller I guess? |
| # |
Jan 30th 2014, 20:42 |
fnfilho |
BackEndCoder, I guess I could make the association on the fly than, so it wont consume 30 queries all the time. but is there a way to do it and still use pagination? |
| # |
Jan 30th 2014, 20:42 |
BackEndCoder |
i forget how tho |
| # |
Jan 30th 2014, 20:42 |
BackEndCoder |
you can override this setting somehow |
| # |
Jan 30th 2014, 20:42 |
kerin |
ACTION nods sagely |
| # |
Jan 30th 2014, 20:42 |
kerin |
mmn |
| # |
Jan 30th 2014, 20:42 |
BackEndCoder |
Fatalnix, yeah technically. it will assume its Cm for the model name |
| # |
Jan 30th 2014, 20:42 |
todds |
ah yes, the deadline-is-approaching-effect. |
| # |
Jan 30th 2014, 20:41 |
kerin |
apologies, i become geometrically stupider when it's 25 minutes before deadline |
| # |
Jan 30th 2014, 20:41 |
kerin |
yeah |
| # |
Jan 30th 2014, 20:41 |
kerin |
i'm an idiot |
| # |
Jan 30th 2014, 20:41 |
BackEndCoder |
try the line abover |
| # |
Jan 30th 2014, 20:41 |
kerin |
wait, nevermind |
| # |
Jan 30th 2014, 20:41 |
BackEndCoder |
kerin, no |
| # |
Jan 30th 2014, 20:40 |
kerin |
$aReturn['events'][$i]['Event']['Promo'] = $EventSponsors[$__eID]; |
| # |
Jan 30th 2014, 20:40 |
kerin |
guys, quick sanity check: why does this contain an unexpected T_VARIABLE |
| # |
Jan 30th 2014, 20:40 |
BackEndCoder |
you basicly need to clone your associtations |
| # |
Jan 30th 2014, 20:40 |
kerin |
gah |
| # |
Jan 30th 2014, 20:40 |
BackEndCoder |
but its a hack |
| # |
Jan 30th 2014, 20:40 |
BackEndCoder |
so if > 1000 it grabes it from comments2 |
| # |
Jan 30th 2014, 20:40 |
BackEndCoder |
and in your qurey |
| # |
Jan 30th 2014, 20:39 |
BackEndCoder |
ok, you would do it by id |
| # |
Jan 30th 2014, 20:39 |
fnfilho |
it was just a matter of performance. So the user table has a column that indicates me where their comments are. technically i just did a "select * from Coments$numChapter where" before |
| # |
Jan 30th 2014, 20:39 |
fnfilho |
all Comment tables have the same structure. But because of the size of the table and older version of MySQL I was getting a lot of crashes... I'm trying remake the script using cake, but without messing with the database |