Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Large Directory Problem

Re: Large Directory Problem

From: Mal Osborne <mal_at_hwhouse.com.au>
Date: 1998/10/03
Message-ID: <OJf8MTn79GA.169@uppssnewspub04.moswest.msn.net>#1/1

Abysmal speed dealing with directories containing a large amount of files is normal, if you are using FAT, I doubt this is the case, but this would give the exact performance problems that you describe. If this is the case, use convert to change the partition to NTFS, and performance should improve dramatically! It may be worth checking out the level of fragmentation on the drive, this can also impact on performance.

--
Malcolm Osborne
MCSE Mensa



Randall wrote in message <36150F83.F7088A06_at_pcmagic.net>...

>Hi!
>
>I'm collecting .jpg images in a single directory. I am going to be
>storing references to them in a database so that I can display them on a
>form and print them on reports. The platform is Windows NT 4.0 SP3
>(Server and Workstations). The application will be in Visual FoxPro 6.0
>or Visual Basic 6.0 (at this point undetermined). The database server
>will be Oracle. Currently an image capture app is creating the images.
>
>At this time I have well over a thousand images in the directory. When
>I open the directory in the NT Explorer or a window I get the flashlight
>waving and it takes several seconds to retrieve the directory. The
>image capture application is taking minutes to write the images to the
>server. (We're replacing the capture software soon because it also trys
>to thumbnail all the images if you go to its file/open dialog).
>
>Is there anything I can do to speed NT's access to this directory? When
>I write my app is there anything I need to be aware of that will
>help/hurt performance in retrieving these images. Some people in my
>organization feel that saving the images in Oracle BLOBs (Binary Long
>OBjects) will server us better. Is that true?
>
>Also, for the NT Gurus, I have given the users on the imaging stations
>Read and Write priviledges on the directory but not Change. If they
>open an existing file and try to modify and save it they are told the
>file is read only. If they create a new file and give it the name of an
>existing file, it will overwrite. Is this a bug? Have I missed
>something in the permissions?
>
>--
>Best!
>
>Randall
>
>[Just my Dog and I at the Edge of the Universe]
> -----------------------------------------
>(Remove "-zzz" from address when replying.)
> ----------------------------------------
>
>
Received on Sat Oct 03 1998 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US