I'm having some issues using multi-queries... I'm using a C++ dialog app with MySQL
5.0.19-nt and MySQL++ 2.3.2 on a Windows XP platform. I have modified the 'multiquery
example' to demonstrate these problems... I cant attach b/c of size limits on this list,
so I guess I can email it seperately (is there a better way?). Here is a summary of the
issues:
1. 'Lost Connection to the MySQL Server'
This seems to happen quite often, and I can make it happen more frequently by limiting the
time between queries. In my program I have a multi-query with about 50-100 mostly updates
being executed every 3 secs or so. It will run fine for hours and then I get this
message. I have added some code to reconnect, which seems to help in most cases but not
all. I have seen a post about a similar problem on the mailing list. I have noticed the
same problem with my modded multiquery app, depending on the value I give the 'Sleep'
function.
2. Memory Leak
I am pretty sure that I have a memory leak as a result of the queries. I have only viewed
the usage in the Windows Task Manager window and I realize that isn't necessarily
accurate, but my app seems to grow and grow from approx 3.5Mb to over 12Mb in 3 hours.
I've turned off other things, etc. and it seems to be the db queries causing it. I have
noticed a similar growth with my modded multiquery app. It is hard to tell for sure as
the usage seems to drop after a while to below its starting level (once only). I think
this is some sort of WIndows garbage collection. However the growth starts again and
continues way past the original point it dropped.
TIA for any help.
Paul Martin
