Hi Percy, I can certainly give you two ideas that most probably will improve your tasks.
1. When appending or updating information in an open table, disable the transaction overhead space by issuing a "Set Table mytable FastEdit On Undo Off" first. 2. If at all possible, use MITab with C++/Delphi/VB instead. It's been proven that even MapBasic benefits from using MITab routines instead of the built-in. Only drawback: you can't update an existing table, only read or write from scratch (afaik). Best regards/Med venlig hilsen Lars V. Nielsen GisPro, Denmark http://www.gispro.dk/ http://www.gispro.biz/ ----- Original Message ----- From: "Bell, Percy" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: "Pearce, Max" <[EMAIL PROTECTED]>; "Gilmour, Glenn" <[EMAIL PROTECTED]>; "Street, John" <[EMAIL PROTECTED]>; "Muir, Jan" <[EMAIL PROTECTED]>; "Brown, Richard" <[EMAIL PROTECTED]>; "Grosvenor-Jones, Terry" <[EMAIL PROTECTED]>; "Arneson, Bronwyn" <[EMAIL PROTECTED]> Sent: Thursday, February 26, 2004 6:26 AM Subject: MI-L Task speeds > Hello to everyone on the list, > > We are trying to squeeze a bit more speed out of MapInfo/MapBasic. > > * We have a number of applications that can take one or two weeks to > complete. > > * We also have the problem of having to build in commit, close all and > pack table statements because it appears that as the TAB files grow they get > unwieldy and task completion time significantly extends. > > * We are trying using a memory based disk replicated out of system > RAM. Certainly the speed of upload is increased as is the first write to > memory when you view full layer. But as applications run, the times do not > seem to have improved. Does anyone have any comments or experience with > using RAM instead of hard disks on complex applications? > > * We understand that page table entries (PTEs) may become depleted or > fragmented on systems that perform a large number input/output (I/O) > actions. When they become completely depleted, the system may show a 'Stop' > error and halt. Has anyone had any success tweaking their system to increase > the number of PTEs available on the system? > > * Is MapBasic building extensive heap storage leading to memory > fragmentation and how might this be overcome? Is there some Windows tuning > parameter, for example working set, that can be changed to hold more of the > process in memory? > > * Is there any way of taking advantage of hyper threading? Or dual > processors? Or both? > > * Can anyone recommend any other approaches? > > * We're running MapInfo/MapBasic on a 3.2 GHZ P4 processor running on > a Epox 4PCA3 motherboard based on the Pentium 875 chip set. There is 2 GB of > DDR 400 RAM and 4 Seagate Barracuda 160 GB drives in a zero/one raid array > using a promise S150 T X 4 PCI Controller. Does anyone have any comments on > this setup? Is there a better way to setup for MapInfo in this type of price > range? > > I'd be really interested to hear of other people's experience with this and > any thoughts you guys might have. > > Cheers > > Percy > > > __________________________________ > > Percy Bell > Communications Research Unit > Department of Communications, IT and the Arts > Ph. (02) 6271 1463 > Fax.(02) 6271 1717 > GPO Box 2154, Canberra ACT 2601 > mailto:[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > http://www.dcita.gov.au <http://www.dcita.gov.au> > > > > > _________________________________________________________________________ > > The information transmitted is for the use of the intended recipient only > and may contain confidential and/or legally privileged material. Any > review, re-transmission, disclosure, dissemination or other use of, or > taking of any action in reliance upon, this information by persons or > entities other than the intended recipient is prohibited and may result in > severe penalties. If you have received this e-mail in error please notify > the Security Advisor of the Department of Communications, Information > Technology and the Arts, telephone (02) 6271-1880 and delete all copies of > this transmission together with any attachments. > > _________________________________________________________________________ > > --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 10609
