Re: [fw-general] Zend_Layout with nested layout?
>
> I'm just playing with Zend_Layout and have a quick question. What I'd
> like to do is have a three part view. I'd like my designer to design a
> wrapper "template" that consists of the markup surrounding the output
> of action views. This is exactly what Zend_Layout does so perfect! but
> if possible I'd like the designer templates to exclude the doctype,
> head and and tag stuff and stick strictly to what comes
> after . That way designers don't need to worry about the non-
> design stuff.
>
> doc.phtml:
>
> PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
> "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd";>
>
>
>
> headTitle() ?>
> headScript() ?>
> headStyle() ?>
>
>
> layout()->content ?>
>
>
>
> which includes the following designer layout.phtml in "content":
>
>
>
> layout()->nav ?>
>
> layout()->content ?>
>
>
> which includes the action.phtml template in "content".
>
You could probably create a view helper like this:
class My_View_Helper_NestedLayout
{
public function nestedLayout($layoutName)
{
try {
$layout = Zend_Layout::getMvcInstance();
echo $layout->render($layoutName);
}
} catch (Zend_Exception $e) {
$this->view->layout($layoutName);
}
}
public function setView(Zend_View_Interface $view)
{
$this->view = $view;
}
}
add the helper path (see
http://framework.zend.com/manual/en/zend.view.helpers.html#zend.view.helpers.custom)
Usage in your main layout (doc.phtml):
...
nestedLayout('content/layout') ?>
...
this would render the layout file 'content/layout.phtml' (relative to your
layout path) at the position where like to render the content.
Please correct me if this might fail in any case!
--
View this message in context:
http://www.nabble.com/Zend_Layout-with-nested-layout--tp15878224s16154p15912857.html
Sent from the Zend Framework mailing list archive at Nabble.com.
Re: [fw-general] Zend_DB performance issue
Yes, I noticed that my request is already listed in the issue tracker -
unfortunately after I wrote my post :)
Btw, I recommend to disable the preparing of sql statements for the MySQL
Adapters by default.
Darby Felton wrote:
>
> Christian Ehmig wrote:
>> Hi!
>>
>> Some time ago I noticed that Zend_DB and especially
>> Zend_Db_Adapter_Abstract
>> prepare ANY statement except when you use the following code fragment:
>>
>> $result = $db->getConnection()->exec('DROP TABLE bugs');
>>
>> The methodology of preparing each statement is necessary for Oracle as
>> far
>> as I remember. Regarding MySQL it has a huge impact on performance
>> instead!
>> The one and only time you need to prepare a statement in MySQL is if you
>> use
>> the prepared query several times with different values bound to the ?
>> parameters.
>>
>> I compared the Zend:DB MySQL adapters to ADO, Pear and Native PHP code
>> inserting 100.000 rows.
>>
>> Code looked something like this:
>>
>> for ($i = 0; $i < 100.000; $i++) {
>>
>> $data = array(
>> 'text' => 'somedummytext'
>> );
>>
>> $db->insert('testtable', $data);
>> }
>>
>> Now, the Zend MySQL adapters send 200.000 queries to the mysql server in
>> this case, a "prepare & execute" for each call to $db->insert().
>>
>> This resulted in double execution time compared to native php access in
>> other words a performance drop of 100%! Of course, SELECT statements
>> (fetchRow, fetchAll, etc.) are prepared, too. Just imagine you use around
>> 100 select queries to render a site - each select will be individually
>> prepared, although this is completely nonsense in my opinion.
>>
>> Are there any plans for disabling the "automatic prepare feature" or any
>> other hints on this issue?
>
> Yes, actually, this is a known issue and planned to be completed soon:
>
> http://framework.zend.com/issues/browse/ZF-1398
>
> Please feel free to jump in and contribute!
>
> http://framework.zend.com/community/contribute
>
> Best regards,
> Darby
>
>
--
View this message in context:
http://www.nabble.com/Zend_DB-performance-issue-tp14233508s16154p14255161.html
Sent from the Zend Framework mailing list archive at Nabble.com.
[fw-general] Zend_DB performance issue
Hi!
Some time ago I noticed that Zend_DB and especially Zend_Db_Adapter_Abstract
prepare ANY statement except when you use the following code fragment:
$result = $db->getConnection()->exec('DROP TABLE bugs');
The methodology of preparing each statement is necessary for Oracle as far
as I remember. Regarding MySQL it has a huge impact on performance instead!
The one and only time you need to prepare a statement in MySQL is if you use
the prepared query several times with different values bound to the ?
parameters.
I compared the Zend:DB MySQL adapters to ADO, Pear and Native PHP code
inserting 100.000 rows.
Code looked something like this:
for ($i = 0; $i < 100.000; $i++) {
$data = array(
'text' => 'somedummytext'
);
$db->insert('testtable', $data);
}
Now, the Zend MySQL adapters send 200.000 queries to the mysql server in
this case, a "prepare & execute" for each call to $db->insert().
This resulted in double execution time compared to native php access in
other words a performance drop of 100%! Of course, SELECT statements
(fetchRow, fetchAll, etc.) are prepared, too. Just imagine you use around
100 select queries to render a site - each select will be individually
prepared, although this is completely nonsense in my opinion.
Are there any plans for disabling the "automatic prepare feature" or any
other hints on this issue?
--
View this message in context:
http://www.nabble.com/Zend_DB-performance-issue-tp14233508s16154p14233508.html
Sent from the Zend Framework mailing list archive at Nabble.com.
