Re: PySQLLite Speed

2004-12-03 Thread Gerhard Haering
On Fri, Dec 03, 2004 at 06:06:11AM -0500, Kent Johnson wrote: > If your data is (or can be) created by an iterator, you can use this recipe > to group the data into batches of whatever size you choose and write the > individual batches to the db. > http://aspn.activestate.com/ASPN/Cookbook/Python

Re: PySQLLite Speed

2004-12-03 Thread Kent Johnson
Kevin wrote: Hello All, I wanted to thank Roger Binn for his email. He had the answer to my issue with writing speed. It's actual made an incredible change in the preformace. I didn't have to go all the way to implementing the synchronous mode(for my app). Previously, I was insert one record at

Re: PySQLLite Speed

2004-12-03 Thread Gerhard Haering
On Thu, Dec 02, 2004 at 08:39:31PM -0800, Kevin wrote: > Hello All, > > I wanted to thank Roger Binn for his email. He had > the answer to my issue with writing speed. It's > actual made an incredible change in the preformace. I > didn't have to go all the way to implementing the > synchronous

Re: PySQLLite Speed

2004-12-03 Thread Gerhard Haering
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 F

Re: PySQLLite Speed

2004-12-02 Thread Adam DePrince
On Thu, 2004-12-02 at 23:39, Kevin wrote: > Hello All, > > I wanted to thank Roger Binn for his email. He had > the answer to my issue with writing speed. It's > actual made an incredible change in the preformace. I > didn't have to go all the way to implementing the > synchronous mode(for my a

PySQLLite Speed

2004-12-02 Thread Kevin
Hello All, I wanted to thank Roger Binn for his email. He had the answer to my issue with writing speed. It's actual made an incredible change in the preformace. I didn't have to go all the way to implementing the synchronous mode(for my app). Previously, I was insert one record at a time. Th

Re: PySQLLite Speed

2004-12-02 Thread Roger Binns
"Kevin" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > 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

Re: PySQLLite Speed

2004-12-02 Thread Robert Kern
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). Th

PySQLLite Speed

2004-12-02 Thread 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 read