Apple

Is that the time for the whole script? Because I suspect the time in the former might be taken up by dealing with the results, rather than fetching them. And that code could possibly be sped up considerably.

I can’t time the whole script because it stops for user input.

But I’m not sure how I could speed this up:

set theCommand to "sqlite3 " & path_to_db & " 'select file_name FROM player_view;' "

set theResult to do shell script theCommand

set theText to paragraphs of theResult

— etc

if newName is in theText then

error newName & " already exists!"

end if

— Jim Weisbin