Re: filemaker pro 7 record ID issues
Re: filemaker pro 7 record ID issues
- Subject: Re: filemaker pro 7 record ID issues
- From: Bruce Robertson <email@hidden>
- Date: Sat, 22 Jan 2005 00:23:55 -0800
> Phillip,
>
> Yes. I get the same results. FileMaker 7 appears to give record numbers from
> 1.0-127.0, then is skips to 3.2768E+4 (or 32768), at the 128th record..
>
> If you change the script to:
>
> get ID of last record as integer
>
> .you will see the real number.
>
> What I observe is that at the 128th record, the ID is 32768, and for every
> record thereafter, the ID is incremented by 1.
>
> Odd yes, I don't see why the jump in ID numbers, but I definitely get the
> same thing.
>
> QUESTION: May I ask this of you? When I run this script to create 1000
> records, is it me or is FileMaker 7 much slower at creating records than its
> predecessor FileMaker 6? It seems to take a great deal of time, and my DB
> only had 1 field.
1. Save.
Whenever looping through large record sets, it is important to use the save
commmand frequently so that Filemaker will save its cache to disk.
tell application "FileMaker Pro 7"
repeat 10 times
repeat 100 times
tell database 1 to create new record
end repeat
save
end repeat
end tell
2. Do no display the status area and use a layout with no fields on it.
1000 records, no status/no fields: 21 seconds
1000 records, show status/fields: 98 seconds
1000 records, hide window: 20 seconds
3. Try duplicate every record:
-- starting with 1 record
tell application "FileMaker Developer"
set x to current date
tell database 1
repeat 10 times
duplicate every record
save
end repeat
end tell
end tell
-- 2 seconds, 1024 records
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Applescript-users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden