« Return to Thread: PDO Sqlite + Zend_DB

Re: PDO Sqlite + Zend_DB

by Matthew Weier O'Phinney-3 :: Rate this Message:

Reply to Author | View in Thread

-- Daniel Rossi <spam@...> wrote
(on Wednesday, 07 May 2008, 02:12 PM +1000):
> This is the error ive discovered
>
> Uncaught exception 'Zend_Db_Statement_Exception' with message 'SQLSTATE[HY000]:
> General error: 10 disk I/O error'

This is an exception being thrown by pdo_sqlite; I suggest googling for
the message to see what potential issues may be.

My guess is it's likely a permissions issue, or a matter of the location
of your sqlite db file (for instance, if it's on a network share, there
may be potential locking issues).

> On 06/05/2008, at 5:57 PM, Daniel Rossi wrote:
>
>
>     Hi there I have noticed a major performance issue when using PDO SQlite
>     with Zend_DB. When I have a certain sqlite function enabled which adds  a
>     temporary key to the sqlite database and then reads the temporary key on
>     another system the cpu resources of apache are quite high. This in turn has
>     made the machine bottle over and cause it to reboot. When i turn the system
>     off and send temporary session id's to the other system the cpu load
>     reduces right away.
>
>     Where could the problem be ? I am pretty stuck on this one ?
>
>

--
Matthew Weier O'Phinney
Software Architect       | matthew@...
Zend - The PHP Company   | http://www.zend.com/

 « Return to Thread: PDO Sqlite + Zend_DB

LightInTheBox - Buy quality products at wholesale price