| # |
Sep 12th 2009, 16:42 |
BlackIce |
besides that it won't be worth it in messyness and maintainability |
| # |
Sep 12th 2009, 16:42 |
BlackIce |
compared to using a cache instead of database for example |
| # |
Sep 12th 2009, 16:42 |
BlackIce |
and the init of a class is very quick, you won't win much there |
| # |
Sep 12th 2009, 16:41 |
BlackIce |
unclezoot: there are opcode cachers like APC for that |
| # |
Sep 12th 2009, 16:41 |
dogmatic69 |
php has almost no over head... cake is fast |
| # |
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 |
^^ |