francky06l schrieb:
Hi!
> Index your aco table on alias ...
>
I have allready done this! The results from the last mail are with this
index!
Bye
Tiggr
Indizes on acos: Name Typ KardinalitätFeld
PRIMARY PRIMARY 433 id
alias_index INDEX 36 alias
tree_ind
Index your aco table on alias ...
On Aug 19, 1:15 am, "Marcus J. Ertl" <[EMAIL PROTECTED]> wrote:
> Marcus J. Ertl schrieb:
>
> Hi again!> I'm afraid, this is poor application design on my side too. :-(
>
> OK, I took a look into this! It was bad design on my side! :-(
>
> I've startet with m
Marcus J. Ertl schrieb:
Hi again!
> I'm afraid, this is poor application design on my side too. :-(
>
OK, I took a look into this! It was bad design on my side! :-(
I've startet with more then 60 queries, taking about 30 seconds! :-(
After taking the check outside the loop, I'm down to 24
mark_story schrieb:
Hi Mark!
> Tiggr: How many queries is ACL component doing. Normally for a single
> check it is ~6 db calls. If you are doing more than one acl check per-
> page you should be caching the results, so you can use them over
> again. But caching is not part of the core ACL compo
You might also index your aros/acos tables, according to the mode used
in Auth ...
On Aug 18, 10:51 pm, mark_story <[EMAIL PROTECTED]> wrote:
> Tiggr: How many queries is ACL component doing. Normally for a single
> check it is ~6 db calls. If you are doing more than one acl check per-
> page y
Tiggr: How many queries is ACL component doing. Normally for a single
check it is ~6 db calls. If you are doing more than one acl check per-
page you should be caching the results, so you can use them over
again. But caching is not part of the core ACL component.
-Mark
On Aug 18, 3:12 am, Tig
Hi!
> var $components = array('Acl', 'Auth', 'Email');
>
> The page load goes through the roof.
Just the same for me, but only with Acl! And it isn't slow all the
time, pages load fast when user isn't logged in, but after logging in,
all is getting worse! Loadtime goes up through the roof becaus