On Wed, 2008-11-19 at 18:40 +0900, Craig Ringer wrote: > Phoenix Kiula wrote: > > > I have googled but it looks like there's a whole variety of > > information from 2003 (when PG must have been quite different) until > > now--some people find stored functions slow for web based apps, others > > find it is worth the maintenance. > > If your web servers are very close in network terms to your database > server, issue mostly non-trivial queries, and are on a low latency link, > it probably doesn't matter *that* much. For one query no... for a dynamic website that uses 100 - 200 queries to draw a page? .... 15ms * 200, 3000ms = 3 secs * 2 (both ways) = 6 seconds. Joshua D. Drake -- -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
