[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