# |
Sep 12th 2009, 16:41 |
unclezoot |
ad7, that sounds like a good compromise |
# |
Sep 12th 2009, 16:41 |
AD7six |
unclezoot: a slim controller and debug = 0 means very little overhead |
# |
Sep 12th 2009, 16:40 |
unclezoot |
well i was thinking more of the overhead of all the dispatcher initialization etc, just to return a list of db results |
# |
Sep 12th 2009, 16:40 |
AD7six |
if you want to be as fast as possible on request 2+ |
# |
Sep 12th 2009, 16:40 |
AD7six |
unclezoot: make it a get request (/x/whatevertheytyped.json), and when you server it write it to the webroot too webroot/x/whatevertheytyped.json) |
# |
Sep 12th 2009, 16:40 |
BlackIce |
what I just said isn't exactly true, but going around cake because your db is slow means your db needs improvement |
# |
Sep 12th 2009, 16:39 |
BlackIce |
your problem* |
# |
Sep 12th 2009, 16:39 |
BlackIce |
you problem won't be just that autosuggest |
# |
Sep 12th 2009, 16:39 |
dogmatic69 |
unclezoot: it will just make a mess |
# |
Sep 12th 2009, 16:39 |
BlackIce |
basically, if you have to go around cake you've got a database structure problem |
# |
Sep 12th 2009, 16:39 |
BlackIce |
unclezoot: what size of table are we talking about? |
# |
Sep 12th 2009, 16:39 |
unclezoot |
yeah i spose, i was just wondering if there's ever any merit in going around cake, specifically for ajax results |
# |
Sep 12th 2009, 16:38 |
unclezoot |
which initially could be very small, but potentially could be very big |
# |
Sep 12th 2009, 16:38 |
dogmatic69 |
you will only return 20 max anyway or your sugest list will be to long |
# |
Sep 12th 2009, 16:38 |
BlackIce |
unclezoot: a mysql index on the first 3 letters would considerably speed that up even without caching |
# |
Sep 12th 2009, 16:38 |
unclezoot |
i type in 3 letters into an input and i want to ajax request the possibilities against a 'tags' table say |
# |
Sep 12th 2009, 16:37 |
AD7six |
unclezoot: I don't follow your example |
# |
Sep 12th 2009, 16:37 |
BlackIce |
what kind of table? |
# |
Sep 12th 2009, 16:37 |
unclezoot |
that's 26^3 permutations |
# |
Sep 12th 2009, 16:37 |
unclezoot |
but say an autosuggest feature where you check for every possible match after the first 3 letters |
# |
Sep 12th 2009, 16:37 |
BlackIce |
unclezoot: so are we :P |
# |
Sep 12th 2009, 16:36 |
unclezoot |
hey guys, im just throwing ideas around im not attacking cake - call off the dogs! :) |
# |
Sep 12th 2009, 16:36 |
BlackIce |
when an item is added to the table that you do the autosuggest on, for example |
# |
Sep 12th 2009, 16:36 |
BlackIce |
and you can cache beforehand |
# |
Sep 12th 2009, 16:36 |
BlackIce |
the first request will be slower, the next wont |
# |
Sep 12th 2009, 16:35 |
dogmatic69 |
with no cache even |
# |
Sep 12th 2009, 16:35 |
BlackIce |
how many items do you need to search? |
# |
Sep 12th 2009, 16:35 |
dogmatic69 |
i find my ajax on cake apps is super fast |
# |
Sep 12th 2009, 16:35 |
unclezoot |
plus, the first request would still be slow as it wouldnt exist in the cache yet |
# |
Sep 12th 2009, 16:35 |
unclezoot |
but say you want an autosuggest feature, then you'd have to cache every attempt no? |
# |
Sep 12th 2009, 16:34 |
BlackIce |
I'd try caching first |
# |
Sep 12th 2009, 16:34 |
BlackIce |
going around cake would be going around the coding easy and maintainability, that's not good |
# |
Sep 12th 2009, 16:33 |
BlackIce |
if you want more speed you can cache |
# |
Sep 12th 2009, 16:33 |
BlackIce |
nope |
# |
Sep 12th 2009, 16:33 |
unclezoot |
on an ajaxupdate, is it worth circumventing cake completely in the interests of speed? |
# |
Sep 12th 2009, 16:26 |
BlackIce |
^^ |
# |
Sep 12th 2009, 16:24 |
edib |
thanks |
# |
Sep 12th 2009, 16:24 |
BlackIce |
after you've checked the docs and api, sure |
# |
Sep 12th 2009, 16:23 |
edib |
anyways, I am new here. If I need some code help, can I find some in here? |
# |
Sep 12th 2009, 16:21 |
BlackIce |
simpler way for what? |
# |
Sep 12th 2009, 16:21 |
kokdemir |
I see, I am looking for simpler way |