Growing memory and MySQL

[Mike]

Hello all,

I'd like to know what I'm doing wrong (certenly I'm doing something wrong). Here is a problem described:

- I have a OnTimer event (TTimer component) defined like this:

MySQLQuery.SQL.Text := 'SELECT CVSKEY FROM CVS WHERE CVSCID=' + IntToStr(ChannelID) + ' AND CVSNBR IS NULL';
MySQLQuery.Open;
CallID := MySQLQuery.Fields[0].AsInteger;
MySQLQuery.Close;

the interval of TTimer is 2000ms. My problem is that after ex. 12 hours of working my application memory usage is very high (over 100MB). What should i free (or something) on each interval? Is there a better way to do select to db?

Thanks in advance,

Mike

[Marc]

if you dont create a MySQLQuery each time in your timer event, this code looks valid. In that case there is a memleak in the TQuery descendent. See if you can pinpoint it with a heaptrace, or file a bugrep at the FPC site (if it aisn't already reported) (or askthe ML if there is such problem known)