PDF file storage
Hey all, Just curious what you all would recommend as the column type for storing a PDB file. We generally store them on the filesystem and just store the location in the database, but if we changed to actually embed them, what is the best plan? So far I'm guessing it should be a byte field and if I need logging it needs to be inline data, and it needs to be in an SBSPACE for HDR. What do you think? Thanks! Kate Tomchik [ kate@iiug.org ] www.iiug.org International Informix Users Group Board of Directors The last person to have this job was a Greek named Sisyphus.
If you use a BYTE column it needs to be IN TABLE to be logged and supported by HDR/RSS/SDS, but ER supports and replicates BYTE even in blobspaces. If you use a BLOB type column then make sure that the sbspace is a logged sbspace for any kind of replication to work. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Wed, May 16, 2012 at 4:29 PM, Kate <kate@iiug.org> wrote: > Hey all, > Just curious what you all would recommend as the column type for storing a > PDB file. We generally store them on the filesystem and just store the > location in the database, but if we changed to actually embed them, what is > the best plan? > > So far I'm guessing it should be a byte field and if I need logging it > needs > to be inline data, and it needs to be in an SBSPACE for HDR. > > What do you think? > > Thanks! > Kate Tomchik [ kate@iiug.org ] www.iiug.org > International Informix Users Group Board of Directors > > The last person to have this job was a Greek named Sisyphus. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --e89a8f3ba959d33abd04c02d61c5
Kate: Can you provide an approximate size of these objects (min,avg,max), there might be a few other solutions that can help. John F. Miller III STSM, Embedability Architect miller3@us.ibm.com 503-578-5645 IBM Informix Dynamic Server (IDS) ids-bounces@iiug.org wrote on 05/16/2012 01:29:50 PM: > From: "Kate" <kate@iiug.org> > To: ids@iiug.org, > Date: 05/16/2012 01:31 PM > Subject: PDF file storage [27156] > Sent by: ids-bounces@iiug.org > > Hey all, > Just curious what you all would recommend as the column type for storing a > PDB file. We generally store them on the filesystem and just store the > location in the database, but if we changed to actually embed them, what is > the best plan? > > So far I'm guessing it should be a byte field and if I need logging it needs > to be inline data, and it needs to be in an SBSPACE for HDR. > > What do you think? > > Thanks! > Kate Tomchik [ kate@iiug.org ] www.iiug.org > International Informix Users Group Board of Directors > > The last person to have this job was a Greek named Sisyphus. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >