Project

General

Profile

Actions

Feature #23374

closed

Add support for prepared queries

Added by Xavier Perseguers over 13 years ago. Updated over 5 years ago.

Status:
Closed
Priority:
Must have
Category:
Database API (Doctrine DBAL)
Target version:
-
Start date:
2010-08-14
Due date:
% Done:

0%

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

Description

Prepared queries would help take better advantage of advanced usage of underlying DBMS and would allow DBAL to be much more efficient by allowing parsed and rewritten queries to be cached.

(issue imported from #M15457)


Files

15457_dbal.diff (12.5 KB) 15457_dbal.diff Administrator Admin, 2010-08-14 19:13
15457_core.diff (20.3 KB) 15457_core.diff Administrator Admin, 2010-08-14 22:04
15457_core_v2.diff (20.6 KB) 15457_core_v2.diff Administrator Admin, 2010-08-14 22:06
15457_dbal_v2.diff (13.6 KB) 15457_dbal_v2.diff Administrator Admin, 2010-08-14 22:07
15457_dbal_v3.diff (15 KB) 15457_dbal_v3.diff Administrator Admin, 2010-08-14 22:52

Related issues 3 (0 open3 closed)

Related to TYPO3 Core - Feature #21614: Add support for MemCacheClosedXavier Perseguers2009-11-19

Actions
Related to TYPO3 Core - Bug #23424: Enhance t3lib_db_PreparedStatementClosedXavier Perseguers2010-08-22

Actions
Related to TYPO3 Core - Feature #27372: Execute native prepared queries in t3lib_DBClosedXavier Perseguers2011-06-11

Actions
Actions #1

Updated by Xavier Perseguers over 13 years ago

v2 implements the TODO of first version:

Find a way to already compile the query into a string while preserving the information
where each parameter appears. This will prevent compiling and compiling again the
query in method stmt_execute() and will allow caching of the query into Memcached and
as such completely bypass the parsing of the already seen before SELECT query.

This will allow #21614 to be fixed.

Actions #2

Updated by Xavier Perseguers over 13 years ago

dbal_v3 fixes issues when really using DBAL (local unit tested with Oracle).

Actions #3

Updated by Xavier Perseguers over 13 years ago

Committed to:

- Core trunk (rev. 8612)
- DBAL trunk (rev. 36983)

Actions #4

Updated by Benni Mack over 5 years ago

  • Status changed from Resolved to Closed
Actions

Also available in: Atom PDF