On 12/13/2012 10:56 AM, Bastien wrote:
Bastien Koert
On 2012-12-13, at 9:10 AM, Jim Giner <jim.giner@xxxxxxxxxxxxxxxxxx> 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?
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
