File object performance

Results 1 to 2 of 2

Thread: File object performance

  1. #1
    Join Date
    Dec 1969

    Default File object performance

    I have set up a web interface for users to retreive PDF files of drawings. They can enter a portion of the part number or a description to get results. Each record in the resulting recordset is run through a function that checks to see if the file exists (if it does, then a hyperlink is created). This works great on folders that have only a few files in them, but bogs down the server if there are more than a dozen.<BR><BR>For example, a search may result in 100 part numbers in the recordset. The function must check the folder and loop thru the contants to see if there is a match. If a match is found then the for loop is exited. So each file in the folder is being compared to every record in the recordset until a match is found.<BR><BR>I&#039;m thinking an array might be a better approach, but I don&#039;t have much experience with them. Maybe the whole approach is wrong and there&#039;s a better way to do it? Any ideas would be helpful.<BR><BR>Thanks.

  2. #2
    Join Date
    Dec 1969

    Default RE: File object performance

    How about adding a field to the database that indicates if the file exists?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts