Subject Re: [firebird-support] Fire bird supper server memory problem
Author Helen Borrie
At 03:25 AM 12/12/2005 +0000, you wrote:
>Hi Friends
>
>we have face one problem with fire bird super server. In front end
>side we are using VB.Net. When we are execute strore procedure or any
>command to firebird database through vb.net on client side fire bird
>supper server memory is increase rapidaly. and it will not release
>after the completion of operation or executing command or store
>procedure.we are using only one connection. so please help us if you
>know..

What you see might be quite consistent with a query or two that traverse a
lot of pages on disk. Each page will be written into the server's page
cache, so memory usage will rise as needed to cache the pages. If the page
size is very large, e.g. 16 Kb, then you are likely to see a fast rise in
memory usage if there are few records per page.

If it seems to be a .net provider issue, then the firebird-net-provider
list is the place to ask.

./heLen

p.s. I need a Firebird version that serves supper. Where did you get
yours? :-)