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 <[EMAIL PROTECTED]> 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 | [EMAIL PROTECTED]
Zend - The PHP Company | http://www.zend.com/
