[Twisted-Python] Scaling problem

Uwe C. Schroeder uwe at oss4u.com
Wed Nov 5 03:12:19 MST 2003


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Tuesday 04 November 2003 01:05 pm, Bill Gribble wrote:
> On Tue, 2003-11-04 at 12:19, Uwe C. Schroeder wrote:
> > BTW: You might suggest to break down the expensive function into smaller
> > pieces - no way. It has to run in one database transaction otherwise I
> > might end up with a inconsistent database - no good in finance business.
>
> Would it help you to have the ability to open a database transaction and
> keep it open while you do other things?  I have a patch to adbapi that
> adds an API to do this.  It's in daily use on my development system but
> I haven't quite finished cleaning it up for submission.

I'm already doing that, but without using adbapi. When I started this project 
adbapi was no choice and now it's simply not an option to rewrite a lot of 
code to something I expect to be even slower than my code. I use a very lean 
row class based on slots and a db interface that handles the schema itself 
without me supplying it. This certainly is database dependant but I can 
afford to support postgres only.

	UC

- --
Open Source Solutions 4U, LLC	2570 Fleetwood Drive
Phone:  +1 650 872 2425		San Bruno, CA 94066
Cell:   +1 650 302 2405		United States
Fax:    +1 650 872 2417
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)

iD8DBQE/qM0DjqGXBvRToM4RAgizAJ93/N/cmUs5MH7oP3xNfhL4loNk4wCgwBaF
b+i2uqarCqQ9nct+MrUuXLQ=
=zh8w
-----END PGP SIGNATURE-----





More information about the Twisted-Python mailing list