On Thu, 2005-07-14 at 08:40 -0600, Joey Ekstrom wrote: > On 7/14/05, Christian Smith <[EMAIL PROTECTED]> wrote: > > Each database would have it's own page cache, which will be the biggest > > memory user. So, with 1K pages, and up to 2000 pages by default, your > > cache footprint would be: > > 1024 * 2000 * 500 = 1024000000 bytes > > ~ 1 GB
It is very unlikely that all 500 database connections will be using maximal cache all at the same time. This seems like a very pessimistic upper bound. > > That looks really good to me. What about the memory cost of prepared > statements? I know with some database drivers that I've used, having > a large number of prepared statements caused the memory usage of the > connections to grow significantly. > Prepared statements use a few KiB each. -- D. Richard Hipp <[EMAIL PROTECTED]>
