Help with speed of processing 
Author Message
 Help with speed of processing

Help! I have 4 data base files I link together to create a tab delimited export
file. the files contain a compay id and all 4 files are linkd using a one to
many releationship. the main company file contain the usuaal stuff like
address. I have 4884 records and it takes 14 hours on a power mac to process.
there is a lot of copy and paste commands in a script I wrote. can anyone tell
me if there ia a better way to copy information from field to field and to copy
information from portholes to portholes I need to add 10000 more address and I
don't look forward to waiting a week just to create the file.

Don




Fri, 19 Jan 2001 03:00:00 GMT
 Help with speed of processing

Quote:

> Help! I have 4 data base files I link together to create a tab delimited
> export file. the files contain a compay id and all 4 files are linkd using
> a one to many releationship. the main company file contain the usuaal
> stuff like address. I have 4884 records and it takes 14 hours on a power
> mac to process. there is a lot of copy and paste commands in a script I
> wrote. can anyone tell me if there ia a better way to copy information
> from field to field and to copy information from portholes to portholes I
> need to add 10000 more address and I don't look forward to waiting a week
> just to create the file.

> Don



Speed of processing depends on several things. One is structure. Why are
you copying and pasting info from field to field?  Properly designed
related databases NEVER duplicate substantive info, only the match or
key fields are duplicated. To make info APPEAR and be useable in more
than one DB is easy using relations. If your information needs to
actually physically exist in more than one DB, you need to examine your
design carefully and get more familiar with the uses of related fields
and portals.  

The fact you call them "portholes" leads me to surmise you haven't spent
as much time with the manual as you might have. ;)  Although it's not a
BAD name for them.  :)

If you MUST transfer information, try the "Set Field" command rather
than copy and paste. But if you are popping from one DB to another,
Copying in one and Pasting into the second, you're going about things
all wrong and no amount of advice is going to speed things up.  A report
that doesn't contain a lot of calculations and summary fields shouldn't
take very long to process, I suspect it's structure and unnecessary
procedures that are slowing you down.  Learn to use related fields in
calculations, layouts and portals. It'll really help.

Once your structure is correct, one thing that can slow down importing
is using large numbers of indexed fields.  However...index up front or
index later, eventually that price must be paid.  Calculations and
summary fields also slow things down in previewing or printing.  

Good luck,
Lynn Allen
Allen & Allen Semiotics         FSA Member - Filemaker Pro Consulting
http://www.semiotics.com        Web & Graphic Design



Fri, 19 Jan 2001 03:00:00 GMT
 Help with speed of processing

Quote:

>Help! I have 4 data base files I link together to create a tab delimited export
>file. the files contain a compay id and all 4 files are linkd using a one to
>many releationship. the main company file contain the usuaal stuff like
>address. I have 4884 records and it takes 14 hours on a power mac to process.
>there is a lot of copy and paste commands in a script I wrote. can anyone tell
>me if there ia a better way to copy information from field to field and to copy
>information from portholes to portholes I need to add 10000 more address and I
>don't look forward to waiting a week just to create the file.

>Don



Don,

    Have you try using the Set Field script step? This step will elimilate
the need of switching layouts. Such as needed in the Copy & Paste operation.
It should no take 14 hours to process 4884 records. Without more detail that
is about all I can say.

Hope it helps.

Lui W.
__________________________________________________
Note: Remove "NOSPAM_" before replying.
__________________________________________________



Fri, 19 Jan 2001 03:00:00 GMT
 Help with speed of processing
Lynn, The 4 file are unique in design with 1 file merging 2 others it as follow
file 1 is a customerdata file containing address information. file 2 is a
product list containing customer id product id and several work fields(globals)
file 3 contains description of products. the 4th file is a work file which
contains a customer id and a work field
I have relations between file 1 and 2 (1 to many) then 2 and 3(a one to one) I
also have a relation from 1 and 4 just to access the file 4
portholes are the only way I have found thus far to create the 4th file which
sole purpose is to accumulate the above 3 files in a  order adding "Quark
Express tags" to select fields. is there a better way to "read"  file 2 it is
almost like an invoice but outputing is a file in tab order (file pro doesn't
allow you to set the delimter) I am willing to sent eith code or samples if you
would like to take a look
Don


Fri, 19 Jan 2001 03:00:00 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. Speed, speed, speed, and Sybase disk limitations

2. Speed, Speed, Speed, and a ramdisk too

3. Speed, speed, speed...

4. Cube processing speed

5. cube size and processing speed.

6. How to increase the speed of process bulk data

7. Processing Speed Reading From SQL vs. Oracle

8. DRILLDOWNLEVEL PROCESSING SPEED and EXECUTION PLAN

9. Speed: Transactions vs. Client Processing

10. Speed Processing Slows Down When Using SQL DB Version 8.0

11. how can i speed up a transfert process?

12. interMedia indexes: how to speed up process


 
Powered by phpBB® Forum Software