Re: mysql_free_result() & 2 different connections

2005-09-21 Thread Miguel Cardenas
> 4.1.4 is beta version, isn't it ? I'll suggest you try the latest > binary for 4.1 available for your setup. Oops, sorry, type mismatch error... I mean 4.1.14, the most recent > > I suspect that the current version of MySQL frees the resources > > automatically, > no, it does not :-) I tho

Re: mysql_free_result() & 2 different connections

2005-09-21 Thread Pooly
Hi, > It is Linux Slackware 10.1 with MySQL 4.1.4 installed from source... I have > tested it too (same program and same version of MySQL) with FreeBSD and the > result is almost the same, the difference is that Linux craches with glib > message and in FreeBSD just sends a warning that the results

Re: mysql_free_result() & 2 different connections

2005-09-20 Thread Miguel Cardenas
> Are your two tables in the same database ? > If yes only one connection if enough, and you could use a join query > to do it, thus having a speed improvement of several magnitudes. I've just downloaded another 2 mysql manuals and have been sit on my chair all day reading them, but still do not

Re: mysql_free_result() & 2 different connections

2005-09-20 Thread Pooly
Hallo, > > in a very small representation the program is this > > *** dbmail and dbmail2 open 2 different connections, one accesses > DBM_ADDRESSES table and the other accesses DBM_NAMES table. The first one > retrieves addresses from the table DBM_ADDRESSES, the second one a relationed > names

Re: mysql_free_result() & 2 different connections

2005-09-20 Thread Miguel Cardenas
> > I have 2 different result sets, since are two different connections to > > the server, simultaneous but independent (two handles, two connections, > > two different queries) > > what is the code you're using ? in a very small representation the program is this *** dbmail and dbmail2 open 2 di

Re: mysql_free_result() & 2 different connections

2005-09-20 Thread Pooly
hi, > I have 2 different result sets, since are two different connections to the > server, simultaneous but independent (two handles, two connections, two > different queries) > > Today was probing one of my programs with just one single connection and > mysql_free_result() still crashes even wi

Re: mysql_free_result() & 2 different connections

2005-09-19 Thread Miguel Cardenas
Hello I was re-reading last mails, analized it carefull again and... > > while ( my1.fetch ) { > >    my2.query + my2.store > >    if ( my2.fetch ) { > >       report = my1 + my2 results > >    } else { > >       report = my1 > >    } > >    my2.FreeResult <--- free for every my2.query inside loo

Re: mysql_free_result() & 2 different connections

2005-09-18 Thread Pooly
Hi, > while ( my1.fetch ) { >my2.query + my2.store >if ( my2.fetch ) { > report = my1 + my2 results >} else { > report = my1 >} >my2.FreeResult <--- free for every my2.query inside loop > } > my1.FreeResult <--- free for unique my1.query One My2.store == One My2.f

mysql_free_result() & 2 different connections

2005-09-17 Thread Miguel Cardenas
Hello list There is another doubt... I have programmed a C++ object that connects to MySQL, it has encapsulated its own MYSQL *mysql MYSQL_RES *result ... etc etc data, so it it possible to have several simultaneous connections to MySQL performing different jobs, but I have experienced a stran