[OSM-dev] Proposed database improvement

Raphael Jacquot sxpert at esitcom.org
Thu Aug 31 10:36:38 BST 2006


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

Nick Hill wrote:

> Using this schema, we can further reduce API load by inserting the
> output of all select statements for a given list of nodes into the one
> temporary table in the single SQL connection, then performing distinctrow.
> 
> The new query takes 28 milliseconds to execute, compared to the existing
> 9 seconds.

is it implemented yet ?
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.5-ecc0.1.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFE9q2cXqd/7Teiu2oRAtHEAKCAvbvgfkceZqy/C9P+P6/vpet5LACgnhu2
hXFCqNp6cpMb9fzufiqJqBc=
=PXOz
-----END PGP SIGNATURE-----




More information about the dev mailing list