[TYPO3-dev] typolink generation high parsetime

[ries van Twisk]

>
>> we did experience the same for a project.
>> A lot of time indeed goes into link generation and
>> we have decided in the end to make a link cache
>> in our application before we request a link from typo3.
>
> Can you share how?

No sorry, I don't work at that company anymore.
But the general idea was that we had a link cache for all generated  
links
we would lookup first prior to let typo3 generate the link.
Each link did had a timeout etc...

This was specially importand because many search engines could crawl
our site and we had seen at list on one occasion that google did
bring our site down after we cleared the cache!!!

We could do this because links didn't change to often, and just like you
we used USER_INT objects a lot because the site was dynamic.

Ries

>
>> What exactly do you want to disable?
>
> Dmitry
> I want to disable this
> Query       SELECT *
>                         FROM pages
>                         WHERE
>                                 uid=82 AND pages.deleted=0 AND
> pages.hidden=0 AND (pages.starttime<=1193318400) AND  
> (pages.endtime=0 OR
> pages.endtime>1193318400)  AND NOT(pages.t3ver_state=1) AND
> pages.doktype<200 AND (pages.fe_group='' OR pages.fe_group IS NULL OR
> pages.fe_group='0' OR (pages.fe_group LIKE '%,0,%' OR  
> pages.fe_group LIKE
> '0,%' OR pages.fe_group LIKE '%,0' OR pages.fe_group='0') OR  
> (pages.fe_group
> LIKE '%,-1,%' OR pages.fe_group LIKE '-1,%' OR pages.fe_group LIKE  
> '%,-1' OR
> pages.fe_group='-1'))
>
> I dont want typoLink to check if destinantion page is available etc
>
>
>