Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Ilya Rabyy
  Where is Ilya Rabyy?
 Fountain Valley
 California - United States
 Ilya Rabyy
 To: Ken Murphy
  Where is Ken Murphy?
 Springhill
 Canada
 Ken Murphy
 Tags
Subject: RE: PDF stored as binary
Thread ID: 112459 Message ID: 112487 # Views: 2 # Ratings: 0
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Thursday, November 09, 2006 12:35:40 AM         
   


> >
> > > I deal with a LOT of image files (30,000+ per year) and I wouldn't even dream of storing them in a table. Where I need to, I store the path and filename in my table and then access the image/pdf/what ever directly.
> > >
> > > If you must, you can store these images in a BLOB or BinaryMemo field. Look at FILETOSTR() and STRTOFILE() in help.
> > >
> > > Ken
> > > You shall know the truth - and the truth shall set you free. (John 8:33)

> >
> > Ken,
> >
> > how many images per subdir you are storing into those subdirs? What's the criteria/-on? Is the number of image files in a given subdir is taken into consideration?
> >
> > Regards,
> >
> > Ilya

>
> Ilya,
>
> I originally stored ALL of them in a single directory but it almost ground to a halt. It worked all right for a month or so as our projects came online with digital cameras. After the third project came on line, we reached a point where it started to get slower and slower. It seems that Windows indexing starts to kack at 1024 files in a directory. Using this logical directory structure, the maximum number of images is equal the the maximum number of children in a sub-project. In our largest sub-project we have 384 children (and that sub-project will probably be split into two subs within the next year.)
>
> Ken
> You shall know the truth - and the truth shall set you free. (John 8:33)

Yeah, we "stpped on this rake" too. Just empirically, we determined that the optimal number of image files in a subdir is at/around 700 for a subdir on a LAN's FS. If it goes through the Web Server, etc., in a classic three-teer setup... I can see where it may stall.

Regards,

Ilya

ENTIRE THREAD

PDF stored as binary Posted by David Jo @ 11/8/2006 8:48:38 PM
RE: PDF stored as binary Posted by Ken Murphy @ 11/8/2006 9:04:55 PM
RE: PDF stored as binary Posted by David Jo @ 11/8/2006 9:08:47 PM
RE: PDF stored as binary Posted by Ken Murphy @ 11/8/2006 9:31:51 PM
RE: PDF stored as binary Posted by David Jo @ 11/8/2006 9:39:48 PM
RE: PDF stored as binary Posted by Ken Murphy @ 11/8/2006 9:44:46 PM
RE: PDF stored as binary Posted by Borislav Borissov @ 11/8/2006 9:50:37 PM
RE: PDF stored as binary Posted by Ken Murphy @ 11/9/2006 12:20:11 AM
RE: PDF stored as binary Posted by David Jo @ 11/8/2006 9:56:03 PM
RE: PDF stored as binary Posted by Ken Murphy @ 11/9/2006 12:18:19 AM
RE: PDF stored as binary Posted by Borislav Borissov @ 11/8/2006 9:34:43 PM
RE: PDF stored as binary Posted by Ilya Rabyy @ 11/9/2006 12:09:54 AM
RE: PDF stored as binary Posted by Ken Murphy @ 11/9/2006 12:28:00 AM
RE: PDF stored as binary Posted by Ilya Rabyy @ 11/9/2006 12:35:40 AM
RE: PDF stored as binary Posted by Borislav Borissov @ 11/8/2006 9:37:32 PM
RE: PDF stored as binary Posted by David Jo @ 11/8/2006 9:42:49 PM
RE: PDF stored as binary Posted by Borislav Borissov @ 11/8/2006 9:47:42 PM