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: 112483 # Views: 2 # Ratings: 0
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Thursday, November 09, 2006 12:09:54 AM         
   


> > Has anybody stored PDF or JPG files in binary format on a SQL Server? I've got a need where I'd much rather have a PDF or JPG converted to binary format and then saved in a SQL record. I'm not sure if this is possible, or even advisable. I'm thinking maybe a hundred pages worth of docs or images in a particular day. Disk space is not an issue, but performance would be.
> >
> > Any insights would be appreciated.
> >
> > Thanks,
> > David

>
> David,
>
> 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

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