Re: storing & searching docs

On Thu, Dec 13, 2012 at 3:10 PM, Jim Giner <jim.giner@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? > > I'm not sure if there's much difference between large text fields and blobs, but I had a database (MySQL) with rows that had one blob each of 5-10 mb. At around 200-300 rows the database was pretty slow. After reaching about 2000 rows, it was terrible. Opening the database with phpMyAdmin (which executes just select with LIMIT 1, 30), took around 6 seconds. Doing a order by on one of the other rows, it took a few minutes.. I tried both InnoDB and MyISAM for storage, but that didn't make much of a difference. So it depends on how large your docs are I guess.. - Matijn