ok there is 1 sql that is the top 10. But if it takes a lot of memory it has to free it memory ?

--- In firebird-support@yahoogroups.com, Thomas Steinmaurer <ts@...> wrote:
>
> > i'm using FB 2.5. There a about 15 users connecting my db. (64 bits)
> > After a while the memory goes from 120 Mb to 500 Mb then 15 minuten later to 800 Mb a few minutes later 1Gb 1,5Gb 2Gb until 6Gb after a few hours. And then stops responding.
> >
> > i did already this query
> >
> > SELECT * from MON$MEMORY_USAGE
> >
> > but i get 488 records but i do not understand what too see there
>
> Have you checked out the Firebird 2.5 release notes p.40ff?
>
> There is also the following example: "Top 10" statements ranked
> according to their memory usage:
>
>
> SELECT FIRST 10
> STMT.MON$ATTACHMENT_ID,
> STMT.MON$SQL_TEXT,
> MEM.MON$MEMORY_USED
> FROM MON$MEMORY_USAGE MEM
> NATURAL JOIN MON$STATEMENTS STMT
> ORDER BY MEM.MON$MEMORY_USED DESC
>
>
> --
> With regards,
>
> Thomas Steinmaurer
> Upscene Productions
> http://www.upscene.com
> http://blog.upscene.com/thomas/
>
> Download LogManager Series, FB TraceManager today!
> Continuous Database Monitoring Solutions supporting
> Firebird, InterBase, Advantage Database, MS SQL Server
> and NexusDB!
>
>
> > wo can help me
> >
> >
> >
> > ------------------------------------
> >
> > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> >
> > Visit http://www.firebirdsql.org and click the Resources item
> > on the main (top) menu. Try Knowledgebase and FAQ links !
> >
> > Also search the knowledgebases at http://www.ibphoenix.com
> >
> > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> > Yahoo! Groups Links
> >
> >
> >
>