PySQLLite Speed

Robert Kern rkern at
Fri Dec 3 02:01:43 CET 2004

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.

I can't comment on PySQLite's speed. However, I do recommend that you 
look at PyTables if all of your data is numerical, as it seems to be.

Robert Kern
rkern at

"In the fields of hell where the grass grows high
  Are the graves of dreams allowed to die."
   -- Richard Harter

More information about the Python-list mailing list