Re: storing & searching docs
| From: | Jim Giner | Date: | Thu, 13 Dec 2012 14:32:58 +0000 |
| Subject: | Re: storing & searching docs | ||
| References: | 1 2 3 4 5 6 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-319872@lists.php.net to get a copy of this message | ||
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:Will this be a concern?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.