dbTalk Databases Forums  

Summary or not summary...?

comp.databases.filemaker comp.databases.filemaker


Discuss Summary or not summary...? in the comp.databases.filemaker forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Aladino
 
Posts: n/a

Default Summary or not summary...? - 07-07-2005 , 05:19 AM






In two database of my solution I need to have summary of founded
records, but never I've interess to have summary of all records, so I
can't decide if I should use summary fields or empty global fields with
a script that calculates summary only on demand. The two database have
now 900 and 23000 records an incrementing 250 and 6000 records/year, and
summary I need are mostly from 20-30 record(sometimes 250) for the first
file and 100-150 for the second; summary fields are 7 on first file and
for in the second and I need only global summary. Will summary fields
slow down my solution or can I use them without any problem?
Adriano B.

Reply With Quote
  #2  
Old   
Helpful Harry
 
Posts: n/a

Default Re: Summary or not summary...? - 07-08-2005 , 07:05 PM






In article <1gzbw9l.xnxxov11k3ptqN%borgobello-NO (AT) SPAM-adriancom (DOT) it>,
borgobello-NO (AT) SPAM-adriancom (DOT) it (Aladino) wrote:

Quote:
In two database of my solution I need to have summary of founded
records, but never I've interess to have summary of all records, so I
can't decide if I should use summary fields or empty global fields with
a script that calculates summary only on demand. The two database have
now 900 and 23000 records an incrementing 250 and 6000 records/year, and
summary I need are mostly from 20-30 record(sometimes 250) for the first
file and 100-150 for the second; summary fields are 7 on first file and
for in the second and I need only global summary. Will summary fields
slow down my solution or can I use them without any problem?
If you put the Summary Fields on another layout, then they won't be
calculated when you're using the main layout. When you need to see /
print the summary values you just change to the other layout (and
depending on how you're summarising records you may need to sort the
found records and enter Preview mode as well).

Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.