Feature #53583
closed
create view in ext_tables.sql
0%
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
Updated by Francois Suter about 11 years ago
- 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.
Updated by Francois Suter about 11 years ago
- TYPO3 Version set to 6.1
But are you sure that views really increase performance? We sometimes use views, but rather for convenience.
Updated by Sabine Deeken about 11 years ago
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)
Updated by Mathias Schreiber almost 10 years ago
- Category set to 999
- Target version set to 8 LTS
- Complexity set to hard
Updated by Gerrit Code Review over 9 years ago
- 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
Updated by Mathias Schreiber over 8 years ago
- Status changed from Under Review to Rejected
this will be handled by doctrine in future versions