If you can get by without it during the -work- then by all means kill them off and and rebuild them when done.
This is especially true if you start at the top of the table and loop all the way to the bottom.
You don't even have to code it, just manually drop the indexing, test it and the rebuild, then if it helps you might want to write a check/kill/rebuild subroutine.
Not mentioned so far is using -integrated- mapping [this may get a bit long but worth the explaination and read]
If it is graphic then MB is often the better choice, but most of the time integration is not that large of a performance hit because the rest of the code is faster.
If you are just -scrubbing- data, then by all means you need to get away from MB.
For DATA ONLY work:
Change the table from TAB over to DBF foramt, then use a database application [excel, dBase, Access,....] or a custom application [Delphi, C, C++, Jiva....] to do the work directly to the DBF file.
NOTE--you must remove and rebuild any indexes
BIG NOTE--you can NOT add or delete any records, only modify them
For DATA with SOME GRAPHIC work:
Use -integrated mapping-
A good starting point would be to download ScriptBuilder
http://www.skbkontur.ru/sb/eng/index.htm
SB will allow you to build and test code without the expense of investing into the full blown versions, but remember that if there is a performance boost then their should be even more by having the code compiled by the commercial IDE. [you can also distribute your code]
By using SB with VBScript, you can import [copy/paste] your MB code with very little modifications. SB also does Delphi, so you can port it to Pascal and gain some additional speed. Also it supports other scripting languages.
I have example code that can help get you going, just drop me a mail
For HEAVY GRAPHIC work:
Integration will still offer some benefits but MB might still be the fastest, you just have to -benchmark- it.
For User Interaction [GUI]:
Any language will be better than MB.
You can possibly code direct to the language for -work- or keep the -work- code in mbx's and just call them.
My $0.0175us
-- Trey Pattillo [EMAIL PROTECTED] www.wap3.com N27.799013 W-97.665322
| If you receive an email that says something like | 'Send this to everyone you know,' | pretend you don't know me.
Data Directions wrote:
I am doing erase, combine and disaggregate operations on 1.3 Gb files, and needless to say, the processing times are ridiculous ... hours and hours .. ad infinitum!
I have implemented the idea of using the MapBasic window and choosing to bypass transaction files by the process:
set table YourTableName fastedit on undo off
Aside from the impractical option of purchasing a Sun Sparc station, would it help if I was to increase my RAM or even processor speed? I am currently running on a 2.4 GHz Pentium 4 with 512 Mb RAM. Or should I maybe consider doing these operations in another product that imports MID/MIF files?
Thanks again,
Bill
--------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 14638
--------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 14646
