PySQLLite Speed

Robert Kern rkern at ucsd.edu
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.

http://pytables.sourceforge.net

-- 
Robert Kern
rkern at ucsd.edu

"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