> using isql/fsql one can supply a CACHE<int> argument at connect time. I > guess that's a temporary page buffers value for this particular > connection, right? > > I've tried Firebird Classic and SuperClassic (I guess it isn't supported > in SuperServer at all). The database has a page buffers value of 75. > Connecting with a CACHE value of 10.000 and doing a SELECT COUNT(*) on a > 1 million record table, won't increase memory usage as expected. Using a > page buffers value of 10.000 at database-level does. > > Any ideas?
Sorry, my fault. It works as expected. Regards, Thomas ------------------------------------------------------------------------------ Xperia(TM) PLAY It's a major breakthrough. An authentic gaming smartphone on the nation's most reliable network. And it wants your games. http://p.sf.net/sfu/verizon-sfdev Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
