Lou,
1. Use XCLASS to override the tt_news methods. Overkill.
2. Create another extension that hooks into tt_news to modifying the
queries being run. Preferred.
Search for hooks in
http://typo3.org/documentation/document-library/extension-manuals/tt_news/3.1.0/view/1/5/
You might check on
Thank you all for your replies. I do not have the capability to
modify the core and make a true relational database unfortunately, I
wouldn't want to change the core like that for fear of incompatibility
and upgrade failure later on.
Do you think I would have any improvement from upgrading and
On 10-11-11 11:12, Victor Livakovsky wrote:
As far, as I understood, these part of queries are generated by
enableFields() of tslib_cObj class, which comes from core, and, I
believe, core members know, what they are doing.
If these queries are really produced by the core I seriously doubt that
Hi,
It's no problem to use LIKE, but if you are using LIKE with a wildcard
at the beginning (LIKE '%,0') MySql is unable to use the index.
http://dev.mysql.com/doc/refman/5.1/en/mysql-indexes.html
The big problem comes from having to deal with comma-separated values to
reference records
Am 14.11.2011 19:58, schrieb Xavier Perseguers:
The big problem comes from having to deal with comma-separated values to
reference records (here fe_groups) instead of real foreign keys.
so how should an ideal query look like instead?
georg
___
Hi,
Georg Ringer wrote:
Am 14.11.2011 19:58, schrieb Xavier Perseguers:
The big problem comes from having to deal with comma-separated values to
reference records (here fe_groups) instead of real foreign keys.
so how should an ideal query look like instead?
(tt_news.fe_group='' OR
HI Xavier,
yeah but how to select then records with 20 pids set, this needs to be a
FIND_IN_SET or IN(), no matter if inside a join or not, right?
georg
___
TYPO3-english mailing list
TYPO3-english@lists.typo3.org
Hi,
On 9-11-2011 21:04, Louis Coppola wrote:
tt_news.endtime1315613160) AND (tt_news.fe_group='' OR tt_news.fe_group
IS NULL OR tt_news.fe_group='0' OR (tt_news.fe_group LIKE '%,0,%' OR
tt_news.fe_group LIKE '0,%' OR tt_news.fe_group LIKE '%,0' OR
tt_news.fe_group='0') OR (tt_news.fe_group LIKE
Hi Georg,
yeah but how to select then records with 20 pids set, this needs to be a
FIND_IN_SET or IN(), no matter if inside a join or not, right?
You use an IN(), yes, no problem (I found once that number of items
within IN is limited in some DBMS. In Oracle 10 for instance IIRC it is
1000.
Hi, Louis.
As far, as I understood, these part of queries are generated by
enableFields() of tslib_cObj class, which comes from core, and, I believe,
core members know, what they are doing.
Most I'm scared about AND tt_news.pid IN(835,2905,...) - there is really
large number of pids. You
Hey Typo3 Friends - I need some help.
We have a large tt_news database (500,000+) records. On certain pages
that contain 4 or more tt_news list content elements, this is causing
a long time for the page to generate (sometimes more then 30 seconds)
and is unacceptable.
After looking through
11 matches
Mail list logo