Re: performance is slow
Federico Di Gregorio <fog-NGVKUo/i/[email protected]>
| Newsgroups | gmane.comp.python.db.psycopg.devel |
|---|---|
| Organization | initd.org |
| Message-ID | <1244668927.4360.1.camel@erin> |
Il giorno mer, 10/06/2009 alle 14.18 -0700, Tim Roberts ha scritto: > Al Niessner wrote: > > Any more suggestions on how to speed things up? The one thing that I do > > not like is that I see the network usage sky rocket during this time. Is > > there a way that I can have a pipe connection instead of network? > > > > Is your database on the same machine as your script? Are you specifying > host='localhost' when you open the connection? If you specify a full > host name, then it's probably connecting to your externally visible IP > address. That is, if the database and the script are on the same server just specify the database name and, as an option, username and password. Don't specify the host or port. federico -- Federico Di Gregorio http://people.initd.org/fog Debian GNU/Linux Developer [email protected] INIT.D Developer fog-NGVKUo/i/[email protected] In science one tries to tell people, in such a way as to be understood by everyone, something that no one ever knew before. But in poetry, it's the exact opposite. -- Paul Dirac _______________________________________________ Psycopg mailing list Psycopg-IAPFreCvJWPBWskQ1e/[email protected] http://lists.initd.org/mailman/listinfo/psycopg
signature.asc
(application/pgp-signature, 197 B)
-----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (GNU/Linux) iEYEABECAAYFAkowI/8ACgkQvcCgrgZGjevQAwCfVoNX82u1OGRKYQO1hcKrZXbF sXgAoLey+3atBtO4NJzSWyKYOx5vsa3x =Phmu -----END PGP SIGNATURE-----