Project

General

Profile

Actions

Feature #53583

closed

create view in ext_tables.sql

Added by Sabine Deeken over 10 years ago. Updated about 8 years ago.

Status:
Rejected
Priority:
Could have
Assignee:
-
Category:
Database API (Doctrine DBAL)
Target version:
Start date:
2013-11-13
Due date:
% Done:

0%

Estimated time:
PHP Version:
Tags:
Complexity:
hard
Sprint Focus:

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

Actions #1

Updated by Francois Suter over 10 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.

Actions #2

Updated by Francois Suter over 10 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.

Actions #3

Updated by Sabine Deeken over 10 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)

Actions #4

Updated by Mathias Schreiber about 9 years ago

  • Category set to 999
  • Target version set to 8 LTS
  • Complexity set to hard
Actions #5

Updated by Gerrit Code Review almost 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

Actions #6

Updated by Mathias Schreiber about 8 years ago

  • Status changed from Under Review to Rejected

this will be handled by doctrine in future versions

Actions

Also available in: Atom PDF