PySQLLite Speed

[Kevin]

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





__________________________________
Do you Yahoo!?
Yahoo! Mail - 250MB free storage. Do more. Manage less.
http://info.mail.yahoo.com/mail_250

 

[Robert Kern]

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
(e-mail address removed)

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

 

[Roger Binns]

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.

Your hard disk.

See the synchronous information in the pragmas:

http://www.sqlite.org/pragma.html

See also:

http://www.sqlite.org/cvstrac/wiki?p=PerformanceConsiderations
http://www.sqlite.org/cvstrac/wiki?p=PerformanceTuning

Roger