Thank you, I will look into those examples.
ralphschindler wrote
>> And on a related issue: In Zf1 you were able to provide a data-type with
>> any
>> query-part, so you were able to actually use optimal data-types for your
>> database (i.e. an int was treated as int). Now even an int gets quoted,
>> which hinders performance on columns that contain the int-datatype. Is
>> there
>
> Can you find me some documentation on this assertion? And, which
> platform you're talking about? (I assume MySQL?)
Indeed, I'm talking about MySql.
This is the signature from the select-objects where method in 1.11.3:
* @param string $cond The WHERE condition.
* @param mixed $value OPTIONAL The value to quote into the
condition.
* @param int $type OPTIONAL The type of the given value
* @return Zend_Db_Select This Zend_Db_Select object.
*/
public function where($cond, $value = null, $type = null)
If this didn't make it into version 2, that would seem kind of strange?
A query like this:
"select * from xyz where id='534'"
is, I think, much slower than
"select * from xyz where id=534",
especially if the id is datatyped as int in Mysql, and even more so when
there is an index on that column.
--
View this message in context:
http://zend-framework-community.634137.n4.nabble.com/Pls-help-with-unwanted-quotes-in-db-queries-tp4659783p4659788.html
Sent from the Zend Framework mailing list archive at Nabble.com.
--
List: [email protected]
Info: http://framework.zend.com/archives
Unsubscribe: [email protected]
