Re: storing & searching docs

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux