Re: List size limit
Re: List size limit
- Subject: Re: List size limit
- From: Malcolm Fitzgerald <email@hidden>
- Date: Sat, 10 Mar 2007 12:36:53 +1100
On 09/03/2007, at 10:48 PM, Simon Forster wrote:
I seem to recall people mentioning on the list that AppleScript lists
start to get a bit flakey above a certain size. 15,000 items OK?
(Back story is that we have a system which stores images on the file
system and references to those images in a FileMaker Pro database. If
the image on the file system is no longer in the database, I'd like to
delete the image. Rather than run a few 100,000 database queries, I
was going to get the current dataset loaded into AppleScript and query
it from there.)
Rather than relying on your data set being sufficiently small to work
within the confines of the language. (A situation which is essentially
coincidental). Why don't you set up a loop to run batches which you
know will be optimal, e.g., 4000. You'll have 15,000 items done in four
loops and 100,000 done in 25 loops. Would that be a terrible
bottleneck?
malcolm
_______________________________________________
Do not post admin requests to the list. They will be ignored.
AppleScript-Users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
Archives: http://lists.apple.com/archives/applescript-users
This email sent to email@hidden