Justtechjobs.com Find a programming school near you






Online Campus Both


php3-list | 199903

Re: [PHP3] File vs blob? From: Adam Gotheridge (adam <email protected>)
Date: 03/28/99

I have been wondering about this myself. How efficient is it to store text
in a blob to be searched on LIKE patterns when the blob field can't be
indexed (as in sybase for example)? Is there a work-around for this, or do
any db's allow a blob to be indexed?

> If you need to make cross-document searches, there really is no
> alternative to store the posts in a database.
>
> - Carsten
>
> John Reekie wrote:
> >
> > Hi folks, I am totally sold on PHP and MySQL, but
> > I was wondering how you decide whether to store text
> > data in a blob or in a file. My initial thought was to
> > store all posted text in files, so that my regular
> > file-based tools (spelling, grep, etc :) would work
> > on them, but I notice that Phorum (for example) stores
> > posts in blobs. 

--
PHP 3 Mailing List   http://www.php.net/
To unsubscribe send an empty message to php3-unsubscribe <email protected>
To subscribe to the digest list:  php3-digest-subscribe <email protected>
For help: php3-help <email protected>  Archive:  http://www.php.net/mailsearch.php3
List administrator:  zeev-list-admin <email protected>