[TYPO3-english] Oracle performance issues

[Philipp Thiele]

Hi Xavier,

2010/7/9 Xavier Perseguers <typo3 at perseguers.ch>

> "Oracle" in the title catched my eyes ;-)
>

When I was writing this mail, I had high hopes for this. Thank you and all
the others for the informative replies.


> Good to know that DAM works. Did you apply some pending patches? Because I
> wrote long ago a patch to support BINARY LIKE queries which were used by DAM
> but it has not been yet committed (should be committed quite soon btw as
> trunk is open for new features).


Yes, in particular the one you mean: http://bugs.typo3.org/view.php?id=12535.

Unfortunately, I have created some own patches for DBAL (most of them are
covered by your patches, and they are more elegant than mine), so that
patching with patches from bugtracker isn't that easy, but I plan to update
the whole system in some weeks. When I do this, I will report the "special"
ones on bugtracker.


> But I know this problem. 8 seconds is quite common with your configuration
> and unfortunately this is a known "problem". I don't name it a bug but a
> nuisance, that's true!
>

I haven't the feeling that this is a bug, too. To show this, I wrote
"issues" in the subject of this mail :o)


> My wish is to allow prepared queries to be understood by SQL parser (not
> that tricky) and by DBAL (first tests show that it's OK too) and then used
> in Core.
>

I had the same idea, but I was afraid of implementing these changes because
I don't know the core and its behaviours so much. But I'm happy to read that
you had already began with this hard work.


> You should stay tuned to the DBAL bugtracker. I'll more or less soon work
> again on this feature and report progress in the already existing thread
> [1]. I'd be more than happy to have you testing the patches I'll provide,
> that'd be great as testers for other DBMS are very hard to find.


I'm very interested in the progress of the DBAL extension. Surely I will
stay tuned and test all the availiable patches :o)


> You may have a look at [2] to understand how you may run a bleeding-edge
> version of DBAL in an "old" TYPO3. Not officially supported but known to
> work :-)
>

I will try this and report the results at Forge. Thank you for this hint.

Kind regards,

Philipp