Re: storing pdf's in database
Paul Thank you. So where did the indexes get stored, in a regular table dbspace or did you need an sbspace ? Thanks, floyd ----- Original Message ----- Subject: Re: storing pdf's in database Date: Thu, April 10, 2008 15:18 From: "Paul Watson (Oninit)" <paul@oninit.com> Floyd Wellershaus wrote: > > We have IDS10.0FC5 on Aix5.3. > > > > Is there a best recommended method for storing and retrieving pdf files > > to the database, that would be put there through an odbc connection > > coming from powerbuilder ? > > > > I am thinking a clob or blob in an sbspace that would be accessed via esqlc. > > > > As an alternative, is there a datablade that would allow the file to be > > stored on the unix OS with the pointer existing in the database ? > > > > Thanks much, > > Floyd > > > > > > I used to use the ETX blade for this. But the actual PDFs were stored > on the filesystem, only the indices where stored in the database. The > ETX blade is very good on PDFs > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > >
On Apr 10, 4:01 pm, "Floyd Wellershaus" <fl...@fwellers.com> wrote: > Paul Thank you. > So where did the indexes get stored, in a regular table dbspace or did you > need an sbspace ? > > Thanks, > floyd > > > > > > ----- Original Message ----- > Subject: Re: storing pdf's in database > Date: Thu, April 10, 2008 15:18 > From: "Paul Watson (Oninit)" <p...@oninit.com> > Floyd Wellershaus wrote: > > > We have IDS10.0FC5 on Aix5.3. > > > > Is there a best recommended method for storing and retrieving pdf files > > > to the database, that would be put there through an odbc connection > > > coming from powerbuilder ? > > > > I am thinking a clob or blob in an sbspace that would be accessed via > esqlc. > > > > As an alternative, is there a datablade that would allow the file to be > > > stored on the unix OS with the pointer existing in the database ? > > > > Thanks much, > > > Floyd > > > I used to use the ETX blade for this. But the actual PDFs were stored > > on the filesystem, only the indices where stored in the database. The > > ETX blade is very good on PDFs > > > _______________________________________________ > > Informix-list mailing list > > Informix-l...@iiug.org > >http://www.iiug.org/mailman/listinfo/informix-list- Hide quoted text - > > - Show quoted text - We store images as bytes in a dbspace so that we can replicate the images to another server via ER. We have fairly consistent file sizes, so we did not need smartblobs. For 4+ million images the retrieve times have never been a problem. We have a keyword index stored as another table in dbspace. That way we let informix handle all the storage and just make sure we feed the engine enough raw disk space to keep shoving in images. We use odbc, but VB (not powerbuilder) as a front end. The setup seems to work fairly well.
I have helped a customer where we use perl(DBI/DBD) to decipher e-mail attachments and upload it to smart blobs in the database, and on the front end they use the Web Datablade module to retrieve, view and manage the documents. Have had no issues with performance so far. I doubt there would be a best recommended method as such, -Manoj caver <dmcbryde@courts.state.va.us> Sent by: informix-list-bounces@iiug.org 04/11/2008 08:10 AM To informix-list@iiug.org cc Subject Re: storing pdf's in database On Apr 10, 4:01 pm, "Floyd Wellershaus" <fl...@fwellers.com> wrote: > Paul Thank you. > So where did the indexes get stored, in a regular table dbspace or did you > need an sbspace ? > > Thanks, > floyd > > > > > > ----- Original Message ----- > Subject: Re: storing pdf's in database > Date: Thu, April 10, 2008 15:18 > From: "Paul Watson (Oninit)" <p...@oninit.com> > Floyd Wellershaus wrote: > > > We have IDS10.0FC5 on Aix5.3. > > > > Is there a best recommended method for storing and retrieving pdf files > > > to the database, that would be put there through an odbc connection > > > coming from powerbuilder ? > > > > I am thinking a clob or blob in an sbspace that would be accessed via > esqlc. > > > > As an alternative, is there a datablade that would allow the file to be > > > stored on the unix OS with the pointer existing in the database ? > > > > Thanks much, > > > Floyd > > > I used to use the ETX blade for this. But the actual PDFs were stored > > on the filesystem, only the indices where stored in the database. The > > ETX blade is very good on PDFs > > > _______________________________________________ > > Informix-list mailing list > > Informix-l...@iiug.org > >http://www.iiug.org/mailman/listinfo/informix-list- Hide quoted text - > > - Show quoted text - We store images as bytes in a dbspace so that we can replicate the images to another server via ER. We have fairly consistent file sizes, so we did not need smartblobs. For 4+ million images the retrieve times have never been a problem. We have a keyword index stored as another table in dbspace. That way we let informix handle all the storage and just make sure we feed the engine enough raw disk space to keep shoving in images. We use odbc, but VB (not powerbuilder) as a front end. The setup seems to work fairly well. _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list