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.
> 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.
-------------- next part --------------
A non-text attachment was scrubbed...
Size: 196 bytes
Desc: Digital signature
More information about the Python-list