> > Rajesh, what do you mean user connects? Really connects or perform
> >first statement? If second, what UDFs do you use? Usually source of
> >memory leaks on server is UDF which don't free used memory or use
> >malloc not from ib_util and FREE_IT directive. You mentioned thin
> >client (I'm not familiar with DBExpress), is'nt application server
> >resident on the same machine and if so can't it buffer large results
> >or forget to free memory? Are datasets on application server
> >unidirectional? In general - don't knowing what your program do we
> >can't help.
> >
> >
>
> The memory shoots up when the user connects to the server not when the
> first statement fires. I ran a timing test to detect this.

Well, that makes sense - the database has a parameter "database page
buffers" and Firebird will allocate memory for those buffers. If you
disconnect right after connecting, the memory should be on the level
as before the connect.



With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird & MS SQL Server.
Upscene Productions
http://www.upscene.com