On Thu, Dec 13, 2012 at 3:32 PM, Jim Giner <jim.gi...@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.gi...@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

Reply via email to