Feature #53583
closed
create view in ext_tables.sql
Added by Sabine Deeken over 10 years ago.
Updated over 8 years ago.
Category:
Database API (Doctrine DBAL)
Description
Hi,
to increase extbase-performance I would sometimes like to create a sql-view of a table.
example:
CREATE VIEW tx_myext_domain_model_highscore AS SELECT uid,pid,name,email,avatar,best_ever FROM fe_users;
Could it be possible to make this work directly with ext_tables.sql?
with the best regards,
Sabine
- Project changed from 1106 to TYPO3 Core
Moving this from Documentation - Core APIs to Core, as this is not related to documentation.
The problem to achieve this is that we need to extend the SQL syntax supported by the TYPO3 Core. It would need to be able to understand the syntax for views. I agree that this could be useful, but it's definitely a lot of work.
But are you sure that views really increase performance? We sometimes use views, but rather for convenience.
Thanks for moving the post.
actually the performance problem is not the fe-user table, this is for convenience,
But another extension-table which has lots of relations and I would like to cut some of them for the listview...
(I have it from the extbase-performance session at typo3 camp Regensburg)
- Category set to 999
- Target version set to 8 LTS
- Complexity set to hard
- Status changed from New to Under Review
Patch set 1 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at http://review.typo3.org/39908
- Status changed from Under Review to Rejected
this will be handled by doctrine in future versions
Also available in: Atom
PDF
Updated by 
Updated by 
Updated by 
Updated by