| # |
Sep 12th 2009, 16:47 |
AD7six |
unclezoot: that's astronomical |
| # |
Sep 12th 2009, 16:47 |
unclezoot |
1.14s |
| # |
Sep 12th 2009, 16:47 |
AD7six |
unclezoot: what does firebug say is the response time for one of these lookups |
| # |
Sep 12th 2009, 16:47 |
dogmatic69 |
its just because of something like async: false in the ajax options |
| # |
Sep 12th 2009, 16:47 |
unclezoot |
and the fields are all indexed etc |
| # |
Sep 12th 2009, 16:46 |
unclezoot |
yes |
| # |
Sep 12th 2009, 16:46 |
dogmatic69 |
you can change that |
| # |
Sep 12th 2009, 16:46 |
AD7six |
unclezoot: are you testing it with debug set to 0 |
| # |
Sep 12th 2009, 16:46 |
unclezoot |
im having a play with a tagging plugin atm which uses remysharp's jquery autocomplete - i noticed that the browser is waiting for the server to return the ajax results, you can't actually type any more letters into your input |
| # |
Sep 12th 2009, 16:45 |
dogmatic69 |
unclezoot: its really easy to do that in beforeSave and afterDelete |
| # |
Sep 12th 2009, 16:45 |
BlackIce |
tnx ^^ |
| # |
Sep 12th 2009, 16:44 |
unclezoot |
blackice, good point well made |
| # |
Sep 12th 2009, 16:44 |
unclezoot |
i like ad7's solution, similar to pseudocoder's solution for building static html in the webroot where possible |
| # |
Sep 12th 2009, 16:44 |
BlackIce |
unclezoot: yes, but you can prevent that by making/refreshing the cache when a item is added |
| # |
Sep 12th 2009, 16:43 |
unclezoot |
of course, that's probably irrelevant in this example |
| # |
Sep 12th 2009, 16:43 |
unclezoot |
i just remember a yahoo article where they said that caching wasnt always the solution, because it presupposes that someone has already made that cache already, in other words, if the user experience is bad on the 1st time they might not come back for the 2nd anyway |
| # |
Sep 12th 2009, 16:43 |
AD7six |
personally, I treat the entire webroot as a cache folder |
| # |
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 |