Project

General

Profile

Actions

Task #56979

closed

Epic #55070: Workpackages

Epic #55065: WP: Overall System Performance (Backend and Frontend)

Epic #55656: Optimize overall Extbase performance

Story #55168: Optimize Extbase generic persistence

Add setting for DataMapper to enable preparedStatements

Added by Marc Bastian Heinrichs over 10 years ago. Updated over 7 years ago.

Status:
Closed
Priority:
Could have
Assignee:
-
Category:
Extbase
Target version:
-
Start date:
2014-03-17
Due date:
% Done:

0%

Estimated time:
TYPO3 Version:
6.2
PHP Version:
Tags:
Complexity:
Sprint Focus:

Description

A big improvement for preparedStatements could be get when there would be a setting in the DataMapper:fetchRelated() (getPreparedQuery) to enable preparedStatements for fetching the relations because the queries would mostly be the same and only differ in the uid.


Related issues 1 (0 open1 closed)

Related to TYPO3 Core - Task #57067: Follow-Up re-use preparedStatement objectRejectedFelix Oertel2014-03-19

Actions
Actions #1

Updated by Xavier Perseguers over 10 years ago

From the implementation of prepared statement I've seen, I have the feeling the prepared statement is recreated for each execution. If I'm correct, and to get most out of it, it should really be reused instead.

Actions #2

Updated by Marc Bastian Heinrichs over 10 years ago

Xavier Perseguers wrote:

From the implementation of prepared statement I've seen, I have the feeling the prepared statement is recreated for each execution. If I'm correct, and to get most out of it, it should really be reused instead.

Oh, yes, I think you are right. At the moment there is absolutely no improvement, if it is enabled in the query settings. The query object will be recreated every time instead of reusing an already created one.

Felix this is not fixed in the query cache patch, is it?

Actions #3

Updated by Felix Oertel over 10 years ago

Urgs ... might be true, not sure. ;) Will try to catch Xavier and have a look at it.

Actions #4

Updated by Helmut Hummel almost 10 years ago

Felix Oertel wrote:

Urgs ... might be true, not sure. ;) Will try to catch Xavier and have a look at it.

What is the status on this one?

Actions #5

Updated by Christian Kuhn over 7 years ago

  • Status changed from New to Closed
Actions

Also available in: Atom PDF