On 12/13/2012 2:40 PM, Bastien Koert wrote:
On Thu, Dec 13, 2012 at 12:41 PM, Matijn Woudt <tijn...@gmail.com> wrote:
On Thu, Dec 13, 2012 at 5:13 PM, Jim Giner <jim.gi...@albanyhandball.com>wrote:
On 12/13/2012 10:56 AM, Bastien wrote:
Bastien Koert
On 2012-12-13, at 9:10 AM, Jim Giner <jim.gi...@albanyhandball.com>
wrote:
Thanks for the input gentlemen. Two opposing viewpoints!
I understand the concept of using files for the docs and a table to
locate them and id them. But I am of the opinion that modern dbs are
capable of handling very large objects (of which these docs are NOT!) much
easier than years ago, so I am leaning that way still. It will certainly
make my search process easier!
More comments anyone?
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
I got away from storing blobs in the db. I noticed significant slowness
after the db grew to about 12gb in MySQL. Back ups also get affected as
they take longer. This was older MySQL. But it also affected my mssql
server the same way.
Nowadays it's files into the file system and data into the db. One thing
you could consider is reading the contents of the into a db field and just
store the text to allow the full text search
Bastien
A very clever idea! I like it - the best of both worlds. Can you sum
up a method for getting the text out of the .doc (or .rtf) files so that I
can automate the process for my past and future documents?
Is there a single php function that would accomplish this?
There's no builtin function for such stuff. doc files are quite tricky to
parse, but rtf files can be parsed pretty easily. One project is PHPRtfLite
[1], which provides you an API for doing this.
- Matijn
[1] http://sourceforge.net/projects/phprtf/
There is
http://stackoverflow.com/questions/188452/reading-writing-a-ms-word-file-in-php
which has some discussion on reading those files with Antiword
(http://www.winfield.demon.nl/)
But I can't get antiword. I'm running windows while my host is running
linux. And there aren't any linux binaries available for download to
put onto my host (assuming that I could do that!). Or am I missing
something.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php