| # |
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? |
| # |
Sep 12th 2009, 16:49 |
unclezoot |
with debug = 0, it's now 462ms |
| # |
Sep 12th 2009, 16:48 |
unclezoot |
thanks for both ideas! |
| # |
Sep 12th 2009, 16:48 |
unclezoot |
that's where im going wrong, plus async: false is worth investigating |
| # |
Sep 12th 2009, 16:48 |
unclezoot |
actually i might still have debug =2, i turned it off in the action but not in the ajax action |
| # |
Sep 12th 2009, 16:48 |
BlackIce |
AD7six: I saw such times before, but that was on a 500mhz P3 with not enough RAM :P |
| # |
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 |