PDO Sqlite + Zend_DB

[Daniel Rossi-2]

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 ?

[Daniel Rossi-2]

This is the error ive discovered

Uncaught exception 'Zend_Db_Statement_Exception' with message 'SQLSTATE[HY000]: General error: 10 disk I/O error'

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-3]

-- 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/

[Daniel Rossi-2]

It looks like for some reason i had to remove all the records and run  
a flush to clear the table and it loads fine. Is it because the  
database was too big perhaps ?

On 07/05/2008, at 11:49 PM, Matthew Weier O'Phinney wrote:

> -- 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/