Hello again Mike, Well, I'm not a trained plumber. :-)
I don't think the problem is directly related to the 30,000+ record loop. I run through over 500,000 records almost every day in single runs. That's not to say there is no leak, but I don't see any errors reported. The two or so times that I have suffered from Pro memory leaks was with a large outer loop and a rather busy interior - certainly more complicated than a simple insert. I was unable to find a way of completing the large batch in one go. I presume the figures quoted below are in KB. A 7MB increase is not too bad. Does your application have to run unattended or 24/7? Will a slow accumulative leak cause problems? It's also worth noting that NT4 does leak a bit sometimes (what SP are you using?), as well as have issues with memory fragmentation. Finally, fastedit on and undo off are pretty essential for batch operations - for speed if nothing else. Regards, Warren Vick Europa Technologies Ltd. http://www.europa-tech.com -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Taylor, Michael Graham Sent: Thursday, January 10, 2002 1:46 AM Cc: Mapinfo List Subject: Re: MI-L MI 6.5 Leaky? Thanks, but it hasn't plugged the leak. It has actually made it worse. I added a commit table myTemp after the insert (not something you'd usually do) to the last program and it effectively doubled the leakage. Using fastedit rather than commiting kept it about the same. I think the telling factor is that the fetch itself is leaking memory. It appears that any read or write operation to a table results in a leak. This is extremely frustrating when working on large tables and makes some of the routines I wish to run practically impossible. I forgot to mention that I have patched MI to Build 31 "Warren Vick, Europa Technologies Ltd." wrote: > > Hello Mike, > > I think I have encountered this problem before with large batch operations. > Try committing the table every so often - I think that's the workaround I > used. For example: > > create table myTemp (id integer) > fetch first from parcel > do until EOT(parcel) > fetch next from parcel > insert into mytemp (id) values (1) > > if parcel.rowid mod 1000 = 0 then ' save every 1000 records > commit table myTemp > end if > loop > > commit table myTemp ' final save > > Regards, > Warren Vick > Europa Technologies Ltd. > http://www.europa-tech.com > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of Taylor, > Michael Graham > Sent: Wednesday, January 09, 2002 11:42 PM > To: Mapinfo List > Subject: MI-L MI 6.5 Leaky? > > Hi > > Recently I've noticed that MI 6.5 (NT) appears to leak memory when > certain mapbasic routines are run. I've finally got around to having a > bit of a look at it and this i what I have found. The following program > causes my memory usage to go from > 118892 to 125464 > This is not released once the program has finished but is released when > MI is exitted. > The table is approx 33000 polygons > > fetch first from parcel > do until EOT(parcel) > fetch next from parcel > loop > > Adding in a create and insert command as follows caused twice the leak > > create table myTemp (id integer) > fetch first from parcel > do until EOT(parcel) > fetch next from parcel > insert into mytemp (id) values (1) > loop > > I am running MI6.5 on a Dell Precision 220 NT4.5 > Is this something to do with my system or are others able to duplicate > it? > > -- > Mike Taylor > ______________________________________________ > GIS Senior Consultant mailto:[EMAIL PROTECTED] > Sinclair Knight Merz Limited http:\\www.skmconsulting.com > Level 12, Mayfair House Tel: +64 4 473 4265 > 54 The Terrace Fax: +64 4 473 3369 > PO Box 10283,Wellington > New Zealand > > _______________________________________________________________________ > List hosting provided by Directions Magazine | www.directionsmag.com | > To unsubscribe, send e-mail to [EMAIL PROTECTED] and > put "unsubscribe MapInfo-L" in the message body. -- Mike Taylor ______________________________________________ GIS Senior Consultant mailto:[EMAIL PROTECTED] Sinclair Knight Merz Limited http:\\www.skmconsulting.com Level 12, Mayfair House Tel: +64 4 473 4265 54 The Terrace Fax: +64 4 473 3369 PO Box 10283,Wellington New Zealand _______________________________________________________________________ List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MapInfo-L" in the message body. _______________________________________________________________________ List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MapInfo-L" in the message body.
