queries and MEMORY LEAKS

hi, I’ve seen that every query eats up a bit of ram, until you run out of available one and block the system

in this specific case i tried to make a new web app, connect to a sql server with session.dbA property in the open event of the session, then i created a webpage button ButtonA in which i use a rowset rA to make a query and then i close this rowset
every time i press the button the app consumes a bit of ram.

session.DBA as MSSQLServerDatabase

session.open
session.DBA as new MSSQLServerDatabase
Session.dbA.DatabaseName=“dbXX”
Session.dbA.Host=“ipXX”
Session.dbA.UserName=“xxAD”
Session.dbA.Password=“xxPW”
Session.dbA.TimeOut=60
session.open end

ButtonA.Action
dim rA as Rowset
rA=Session.dbA.SqlSelect(“select a,b,c from tblA”)
ra.close
ButtonA.action end

every time I press the ButtonA, the app eats a bit of ram, even if I close the connection to the db at session level.

What version of xojo are you using, I found and reported lots of database related leaks recently and they are being/have been fixed already in the latest release.

rel. 2.1 fixed this problem