PySQLLite Speed
Robert Kern
rkern at ucsd.edu
Thu Dec 2 20:01:43 EST 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