Filemaker Show faster than Find
Filemaker Show faster than Find
- Subject: Filemaker Show faster than Find
- From: Gil Dawson <email@hidden>
- Date: Thu, 10 Mar 2005 23:50:18 -0800
Title: Filemaker Show faster than
Find
My simple timing tests suggest that with Filemaker Pro V6.0 show
is significantly faster than find. Can anyone corroborate this
conjecture? Does it apply generally to all constructs of show vs
find, or is find faster sometimes?
--Gil
Show:
set
{TopEdge, BottomEdge, LeftEdge, RightEdge} to ¬
{37.7, 36.7, -123.2,
-122.2}
set
t0 to current date -- THack
set
nReps to 20 -- THack
repeat nReps
times --
THack
tell
application "FileMaker Pro"
show every
record
show
(every record
whose ¬
cell
"Latitude" is less
than TopEdge and ¬
cell
"Latitude" is greater
than BottomEdge and ¬
cell
"Longitude" is greater
than LeftEdge and ¬
cell
"Longitude" is less
than RightEdge and ¬
((cell "Nix" is
equal to "") or (cell
"Nix" is equal
to " ")))
end
tell
end repeat -- THack
set
DeltaT to ((current
date) -
t0) /
nReps --
THack
log
"Seconds per loop=" &
DeltaT --
THack
DeltaT
--0.35, 0.4
Find:
set
t0 to current date -- THack
set
nReps to 20 -- THack
repeat nReps
times --
THack
tell application
"FileMaker Pro"
delete every
request
create request
create request with
properties {omitted:true}
set cell "Latitude"
of request 1 to "<"
& TopEdge
set cell "Longitude"
of request 1 to "<"
& RightEdge
set cell "Nix"
of request 1 to
"="
set cell "Latitude"
of request 2 to "<"
& BottomEdge
set cell "Longitude"
of request 2 to "<"
& LeftEdge
find
end
tell
end repeat -- THack
set
DeltaT to ((current
date) -
t0) /
nReps --
THack
log
"Seconds per loop=" &
DeltaT --
THack
DeltaT
--.55
Times shown are on a 1.33 GHz Powerbook G4 12" running
Script Editor 2.0 under MacOS 10.3.8 and the "Event Log History"
window set to "Log Nothing".
_______________________________________________
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