PySQLLite Speed

Gerhard Haering gh at ghaering.de
Fri Dec 3 09:35:39 CET 2004


On Thu, Dec 02, 2004 at 04:22:25PM -0800, Kevin wrote:
> Hello All,
> 
> I wondering if anyone has encountered the same issue
> with using PySQL.  This is my first time using this DB
> so this preformance may be typical.  I'm reading an
> ASCII file through PyParse that contains about 1.3Meg
> of Float data.  8000 Triangles (3 Vertexes and 1
> Normal).  This file reads fine the PC has a
> utilization of 50% for Python.  Then when it starts to
> write the Database, the PC Util drops to 1-2% and it
> takes forever.  I'm not PC related preformance
> barriers that I'm aware of.
> 
> Regards,
>        Kevin
> 
> OS : Windows
> PySQLLite Version: 1.1.5

You're not doing silly things like using pysqlite's autocommit mode or
.commit()-ing too often, are you?

Like already mentioned, PRAGMA SYNCHRONOUS should boost performance.

-- Gerhard
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 196 bytes
Desc: Digital signature
URL: <http://mail.python.org/pipermail/python-list/attachments/20041203/562242bb/attachment.pgp>


More information about the Python-list mailing list