NYCPHP Meetup

[Fee, Patrick J (US SSA)]

Aj,

What about a verity search?  The later versions of the verity search engine is a LOT less buggy that the earlier versions.  And then you also open the door to searching other binary files as well (e.g.:Word, Excel, Powerpoint, PDF files that have been OCR'd).  Then you could keep the files in a directory stucture rather than as BLOBs or CLOBs.

The only drawback is that you might need two search queries... one for information kept in a db (certain file information or other unrelated info) and another for the files indexed by the Verity search engine. In my work with ColdFusion, the last couple of versions allow for a Select query that has multiple searches in one query (e.g. search this db and then do this Verity search and return the aggregate results into one page).  Perhaps php may have a simiar query method?

Just some Thursday afternoon musings.....

Patrick J. Fee 
202-203-6950 (desk)
240-401-6820 (cell)
BAE SYSTEMS
Patrick.Fee at BAESystems.com



-----Original Message-----
From: talk-bounces at lists.nyphp.org
[mailto:talk-bounces at lists.nyphp.org]On Behalf Of Ajai Khattri
Sent: Thursday, August 12, 2004 2:13 PM
To: NYPHP Talk
Subject: [nycphp-talk] Files or BLOBs??



Im planning a web-based application where users upload text files to a 
site where they are stored and can be searched, viewed, edited, etc. My 
first instinct is to use some database to make indexing and searching 
nice and fast. However, each file can vary from 26K to 35K - and I think 
this is rather large to store in a column in MySQL so maybe I will have 
to use files and use MySQL to store meta-data about the file. What do 
you guys consider a good approach for this sort of thing?

-- 
Aj.
Systems Administrator / Developer

_______________________________________________
New York PHP Talk
Supporting AMP Technology (Apache/MySQL/PHP)
http://lists.nyphp.org/mailman/listinfo/talk
http://www.newyorkphp.org