| # |
Sep 12th 2009, 17:13 |
skapism |
I tried with going with the condition of Model.id DESC, but that forces me to use find('all') and loop through the records, I thoguht it was possible to do it with find('first') |
| # |
Sep 12th 2009, 17:12 |
AD7six |
skapism: calling find('list') is a pretty accurate emulation |
| # |
Sep 12th 2009, 17:12 |
unclezoot |
no, im giving you the background of where ive started from and then where ive found a problem, and so the motivation for asking my question about speeding up ajax requests |
| # |
Sep 12th 2009, 17:12 |
skapism |
what would be the best way to emulate a find('last')? |
| # |
Sep 12th 2009, 17:12 |
AD7six |
or perhaps more accurately, it's the exact oposite of what I'm suggesting you do (reduce your lookup controller code to a minimum) |
| # |
Sep 12th 2009, 17:11 |
AD7six |
unclezoot: I don't see how what you've linked to is related to what you're asking |
| # |
Sep 12th 2009, 17:06 |
unclezoot |
well it's a plugin (http://www.formation-cakephp.com/259/plugin-tags-multi-modeles), 1 helper, 2 models |
| # |
Sep 12th 2009, 17:05 |
AD7six |
unclezoot: build? how many model,s and helpers are you using to serve json? |
| # |
Sep 12th 2009, 17:04 |
AD7six |
it also more or less points out the cost is in your app |
| # |
Sep 12th 2009, 17:04 |
unclezoot |
how about if i have an empty $uses array, but build it on the fly per action with CRI, same with helpers , and then use view caching? |
| # |
Sep 12th 2009, 17:04 |
AD7six |
yes it's reasonable |
| # |
Sep 12th 2009, 17:03 |
AD7six |
anyway; if the model you're querying has associations - use a different model with no associations. use a controller with not components and no helpers - and enable view caching unless you choose the webroot trick. that should get yo ubelow 200ms |
| # |
Sep 12th 2009, 17:03 |
unclezoot |
is that reasonable? |
| # |
Sep 12th 2009, 17:02 |
unclezoot |
92ms for a 17k css file |
| # |
Sep 12th 2009, 17:02 |
AD7six |
why didn't you just use the favicon/an image/a css/a js file |
| # |
Sep 12th 2009, 17:01 |
unclezoot |
58ms for the smallest html file i could make |
| # |
Sep 12th 2009, 17:00 |
AD7six |
heh it's a property |
| # |
Sep 12th 2009, 16:59 |
AD7six |
~tell thun_ about api useTable |
| # |
Sep 12th 2009, 16:59 |
unclezoot |
good question ill find out |
| # |
Sep 12th 2009, 16:59 |
AD7six |
unclezoot: what's your response time for any static file in your webroot |
| # |
Sep 12th 2009, 16:59 |
thun_ |
So im trying to grab some data out of another table on a diff datasource. It's in a table called User. I have a table called User on my site. Can I have a model that has a diff table name then the name of the model? |
| # |
Sep 12th 2009, 16:59 |
unclezoot |
in some bizarre way, i think it replicates a server under load :P |
| # |
Sep 12th 2009, 16:58 |
unclezoot |
maybe then it's all the crap i have running at the same time i suppose |
| # |
Sep 12th 2009, 16:57 |
AD7six |
unclezoot: I doubt your choice of os etc is responsible for still more-than-doubling your response time |
| # |
Sep 12th 2009, 16:56 |
unclezoot |
well im using wamp on this laptop so i daresay it can be tweaked a hell of lot more |
| # |
Sep 12th 2009, 16:56 |
AD7six |
unclezoot: some profiling would help find out what. as you kind of pointed out, caching isn't your answer (although it's subsequently help) |
| # |
Sep 12th 2009, 16:55 |
AD7six |
unclezoot: >1s is unusable 1/2s with debug = 0 probably means you have something not right in your setup |
| # |
Sep 12th 2009, 16:54 |
unclezoot |
"async: false" seems to be a known limitation of remysharp's autosuggest plugin, and changing it to true breaks it, so ill have to grin and bear the delay it seems |
| # |
Sep 12th 2009, 16:53 |
BlackIce |
np |
| # |
Sep 12th 2009, 16:53 |
thun_ |
kk ty |
| # |
Sep 12th 2009, 16:52 |
BlackIce |
$this->useDbConfig or something like that |
| # |
Sep 12th 2009, 16:52 |
BlackIce |
check the books ;) |
| # |
Sep 12th 2009, 16:52 |
thun_ |
ok.. how do I set a model to always use another datasource? |
| # |
Sep 12th 2009, 16:51 |
BlackIce |
you can easily screw up your cache by using such tricks |
| # |
Sep 12th 2009, 16:51 |
thun_ |
ahh |
| # |
Sep 12th 2009, 16:51 |
BlackIce |
which will represent that other table |
| # |
Sep 12th 2009, 16:51 |
BlackIce |
if you need access on a table on another database you could make another model for it |
| # |
Sep 12th 2009, 16:51 |
thun_ |
I need to grab some info from that side in this model function |
| # |
Sep 12th 2009, 16:51 |
thun_ |
It is... but I have another site runnign on the server |
| # |
Sep 12th 2009, 16:50 |
BlackIce |
a model should be tied to one table |
| # |
Sep 12th 2009, 16:49 |
thun_ |
How do I switch my datasource from within a model for one query then switch back? |