Forum OpenACS Q&A: Response to How would one handle 12,000 db backed request per second?
You can't really help people unless you've played with some 12,000 db backed request per second sites--but sure--try. Some of the people try.
This thread has a sister thread on www.arsdigita.com/asj under this link: http://www.arsdigita.com/bboard/q-and-a-fetch-msg?msg%5fid=000dh9&topic%5fid=web%2fdb&topic=
Keywords for future searchability: Caching, Server Replication, Domain and Data Partitioning, Scaling Oracle (Book), Oracle, Oracle Tuning, Oracle Benchmarks, SQL Server, Extended Procedures, Store Procedures, Triggers, Dynamically update caching, dependency tree, client-side caching, server-side caching, Cisco Local Director, IBM Austin Research, CS Berkeley SEDA Project, C10K, asynchronous I/O, non-blocking i/o, Low context-switching cost, Olympic Website '98 '96 '00, state-less programming, clusters, Linux kernel, BSD kernel, Flash webserver, Squid proxy server, Zeus webserver, util_memoize.
(hopefully) Helpful links: http://www.elementkjournals.com/sql/0002/sql0021.htm.