Re: storing & searching docs

On Thu, Dec 13, 2012 at 3:32 PM, Jim Giner <jim.giner@albanyhandball.com>wrote: > On 12/13/2012 9:19 AM, Matijn Woudt wrote: > >> On Thu, Dec 13, 2012 at 3:10 PM, Jim Giner <jim.giner@albanyhandball.com> >> **wrote: >> >> >>> >>> 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 >> >> My docs are very small. Two hour meetings, 4 typed pages usually, so > approx. 8K of real data each. I don't think storage is much of a concern > here. The actual "doc" formats are around 28K and when converted to RTF > they grow to 44K - still not very large. > > Will this be a concern? > > That of course also depends on how many you are planning on storing. I guess a few hundred will be ok, but after that I'm not so sure.. - Matijn