| # |
Sep 12th 2009, 17:34 |
dogmatic69 |
cos your sql is about 2 - 5ms |
| # |
Sep 12th 2009, 17:34 |
dogmatic69 |
yip |
| # |
Sep 12th 2009, 17:34 |
unclezoot |
speedwise |
| # |
Sep 12th 2009, 17:34 |
dogmatic69 |
unclezoot: caching the modle would not give much |
| # |
Sep 12th 2009, 17:34 |
unclezoot |
i suspect static html would be the way forward |
| # |
Sep 12th 2009, 17:33 |
dogmatic69 |
lol |
| # |
Sep 12th 2009, 17:33 |
unclezoot |
but if i had time, id try both and compare |
| # |
Sep 12th 2009, 17:33 |
unclezoot |
my conclusion is the administrators can get stuffed and im not going to bother with any caching because i still have to finish the rest of this app first |
| # |
Sep 12th 2009, 17:32 |
BlackIce |
unclezoot: and, what was your conclusion? |
| # |
Sep 12th 2009, 17:32 |
thun_ |
I used useDbConfig and useTable but when I run it I get "Database table advantages for model Advantage was not found." the name of the model is Advantage but i called useTable users... how do I start debugging this? |
| # |
Sep 12th 2009, 17:32 |
unclezoot |
BlackIce, i was debating which form of cache would be best, either creating a static file in httpdocs, or caching the model in /tmp |
| # |
Sep 12th 2009, 17:23 |
renan_saddam |
~bin |
| # |
Sep 12th 2009, 17:21 |
BlackIce |
oh model caching, just use cake's cache? |
| # |
Sep 12th 2009, 17:21 |
unclezoot |
model caching you mean? |
| # |
Sep 12th 2009, 17:20 |
BlackIce |
unclezoot: cache/? |
| # |
Sep 12th 2009, 17:19 |
unclezoot |
now im wondering on the best generic httpdocs folder stucture for view caching an autosuggest :) |
| # |
Sep 12th 2009, 17:17 |
unclezoot |
basically, there's a helper which calls remysharp's js, which uses async: false so you have to wait for the results to ajaxload before you can enter another letter in the input. this means you have to twiddle your thumbs (on my machine at least) whilst you wait for the server response |
| # |
Sep 12th 2009, 17:16 |
unclezoot |
try this, http://github.com/josegonzalez/tagging/tree/master, savant forked the code (to make it php4 compatible), looks at section 2.3.b if you have the inclination |
| # |
Sep 12th 2009, 17:15 |
skapism |
really.realise |
| # |
Sep 12th 2009, 17:15 |
skapism |
I didn'T really there is a difference between all and first in the ordering naming convention |
| # |
Sep 12th 2009, 17:15 |
skapism |
AD7six: ignore me, I was using order by and not order |
| # |
Sep 12th 2009, 17:15 |
AD7six |
unclezoot: ic, I don't see where the ajax request goes |
| # |
Sep 12th 2009, 17:14 |
AD7six |
skapism: what forced you to do what? |
| # |
Sep 12th 2009, 17:13 |
unclezoot |
it's a tagging plugin which can perform an ajax update to suggest tags, atm that feature is a bit slow |
| # |
Sep 12th 2009, 17:13 |
skapism |
I see |
| # |
Sep 12th 2009, 17:13 |
xkunalx |
hi AD7six |
| # |
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 |