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