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.
