Hello all,
I started working with ZF2, and I want to get a list of all columns in database
table. If I do something like:
$metadata = new Metadata($adapter);
$columns = $metadata->getColumns('table_name');
it takes about half a second to do it. Adapter was created with Pdo_Mysql as
the driver.
Why is it so slow?
It should be an equivalent of:
SELECT * FROM information_schema.columns WHERE table_schema = ? and table_name
= ?
That query takes milliseconds to complete on the same adapter.
Any ideas why getColumns is so slow and if it can be optimized?
Thanks,
Dejan
--
List: [email protected]
Info: http://framework.zend.com/archives
Unsubscribe: [email protected]
