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
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
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
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
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
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
"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
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
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