Memory hogging with TSQLQuery
Publicado: Lun Oct 22, 2007 7:00 pm
My Xailer apps are eating up a lot of memory, (slowing down everything on
the PC) then they choke and die. It happens when I open/close open/close
open/close forms with TMySQLDataSource and TSQLQuery datasets.
When I look at the memory consumption of the apps in Task Manager I see that
the app do not release any amount of memory (well, a *very* small amount is
sometimes released) when :Close()'ing or :End()'ing the forms. The larger
the datasets are, the faster the app choke up and die. This only happens
with forms containing the above mentioned MySQL datacontrols.
I can give you an example but with my Xailer v1.6.6 the behaviour is equal
no matter how advanced or simple test samples I make. Just put a MySQL
browse and a DBNavigator on a child form and watch Task Manager when you
open/close open/close the child browse from.
Regards,
Paal
the PC) then they choke and die. It happens when I open/close open/close
open/close forms with TMySQLDataSource and TSQLQuery datasets.
When I look at the memory consumption of the apps in Task Manager I see that
the app do not release any amount of memory (well, a *very* small amount is
sometimes released) when :Close()'ing or :End()'ing the forms. The larger
the datasets are, the faster the app choke up and die. This only happens
with forms containing the above mentioned MySQL datacontrols.
I can give you an example but with my Xailer v1.6.6 the behaviour is equal
no matter how advanced or simple test samples I make. Just put a MySQL
browse and a DBNavigator on a child form and watch Task Manager when you
open/close open/close the child browse from.
Regards,
Paal