Thanks for the report, and the test-application. There was another resource-leak. Fixed in revision 3308.
On Wed, 2006-04-19 at 10:05 +0200, Sainty wrote: > > ----- Original Message ----- > > From: "Michael Van Canneyt" <[EMAIL PROTECTED]> > > To: <[email protected]> > > Cc: "Sainty" <[EMAIL PROTECTED]> > > Sent: Thursday, April 06, 2006 11:15 PM > > Subject: Re: [lazarus] Growing memory and MySQL > > > > > >> > >> > >> On Thu, 6 Apr 2006, Vincent Snijders wrote: > >> > >>> Sainty wrote: > >>> > Hello all, > >>> > > >>> > I'd like to know what I'm doing wrong (certainly I'm doing something > >>> > wrong). Here is a problem described: > >>> > > >>> > - I have an OnTimer event (TTimer component) defined like this: > >>> > > >>> > begin > >>> > MySQLQuery.SQL.Text := 'SELECT CVSKEY FROM CVS WHERE CVSCID=1'; > >>> > MySQLQuery.Open; > >>> > CallID := MySQLQuery.Fields[0].AsInteger; > >>> > MySQLQuery.Close; > >>> > end; > >>> > > >>> > The interval of TTimer is 2000ms. My problem is that after 12 hours of > >>> > working my application memory usage is very high (over 100MB). What > >>> > should I free on each interval? Is there a better way to do that kind > >>> > of > >>> > select to MySQL db? > >>> > > >>> > Thanks in advance, > >>> > > >>> > >>> I don't know the internals, but saw this patch recently applied to fpc > >>> 2.1.1: > >>> http://www.freepascal.org/cgi-bin/viewcvs.cgi/trunk/fcl/db/sqldb/mysql/mysqlconn.inc?rev=3149&sortby=date&view=diff&r1=3149&r2=3148&p1=trunk/fcl/db/sqldb/mysql/mysqlconn.inc&p2=/trunk/fcl/db/sqldb/mysql/mysqlconn.inc > >>> > >>> Maybe this can explain the behavior you are seeing. > >> > >> There was a resource leak in mysqlconn, which I too encountered recently. > >> Joost has fixed it. > >> > >> Michael. > > Hello again, > > I've tested my application again with win32 snapshot from 18-04-2006, which > already contain fixed resource leak described > > http://www.freepascal.org/cgi-bin/viewcvs.cgi/trunk/fcl/db/sqldb/mysql/mysqlconn.inc?rev=3149&sortby=date&view=diff&r1=3149&r2=3148&p1=trunk/fcl/db/sqldb/mysql/mysqlconn.inc&p2=/trunk/fcl/db/sqldb/mysql/mysqlconn.inc > > but I still have got the same problem with growing memory. I'm not sure if > I'm doing everything ok. For fast investigation I've prepared some demo > project with mysql and ttimer, you can download it at: > http://www.wsisiz.edu.pl/~zaleski/mysql_ttimer.zip (~600KB) > > thanks in advance, > > Sainty > > > > ---------------------------------------------------------------------- > Poznaj Stefana! Zmien komunikator! >>> http://link.interia.pl/f1924 > > _________________________________________________________________ > To unsubscribe: mail [EMAIL PROTECTED] with > "unsubscribe" as the Subject > archives at http://www.lazarus.freepascal.org/mailarchives > -- Met vriendelijke groeten, Joost van der Sluis CNOC Informatiesystemen en Netwerken http://www.cnoc.nl _________________________________________________________________ To unsubscribe: mail [EMAIL PROTECTED] with "unsubscribe" as the Subject archives at http://www.lazarus.freepascal.org/mailarchives
