|Subject||Re: [firebird-support] Re: Performance Degrade - HELP|
> > Rajesh, what do you mean user connects? Really connects or performWell, that makes sense - the database has a parameter "database page
> >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.
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.
Database Workbench - developer tool for InterBase, Firebird & MS SQL Server.