[TYPO3-core] RFC #11712: Feature: t3lib_BEfunc::selectVersionsOfRecord: Need a Hook for query-building
Rupert Germann
rupi at gmx.li
Thu Aug 20 14:32:50 CEST 2009
FYI: set bug to resolved on Mathias' request.
rupert
Mathias Gisch schrieb:
> This is an SVN patch request.
>
> Type: New feature
>
> Bugtracker references:
> http://bugs.typo3.org/view.php?id=11712
>
> Branches:
> Trunk
>
> Problem:
> The selectVersionsOfRecord()-function selects all records based on the
> uid or t3ver_oid in combination with the pid field. This is very
> ineffective in large datasets as it is not possible to setup a
> MySQL-multicolumn-index here. So a full tablescan has to be performed
> every time.
> For large datasets it is faster to do a union select for records with
> the uid, and records with the t3ver_oid and pid, as I can use
> multicolumn-indices in both queries. A subselect might also be suitable
> in some occasions.
>
> Solution:
> I propose to introduce a hook in t3lib_BEfunc::selectVersionsOfRecord()
> which enables me to build my own queries based on the table that is
> beeing queried:
> $TYPO3_CONF_VARS']['SC_OPTIONS']['t3lib/class.t3lib_befunc.php']['selectVersionsQuery'][$table]
>
> The hook just builds the sql-string. The query will then be submitted
> and processed by the t3lib_BEfunc::selectVersionsOfRecord()-function.
>
>
> Greetings,
> Mathias
>
>
>
More information about the TYPO3-team-core
mailing list