NYCPHP Meetup

NYPHP.org

[nycphp-talk] LARGE mysql database performance

inforequest 1j0lkq002 at sneakemail.com
Tue Jan 31 17:59:51 EST 2006


Keith Richardson keith-at-keithjr.net |nyphp dev/internal group use| wrote:

> So I am writing a "security camera" app at work, and using mysql/php. 
> I have the cameras uploading snapshots via ftp to the server.
>
> Now for dealing with the images, and indexing them for easy searching, 
> I want to throw the info into a mysql database. I wouldnt mind also 
> sticking the image data in the table too, so that you HAD to go 
> through the app to view the images instead of direct url linking, but 
> was wondering, how does mysql react with a 20-30gb database? would 
> this be very bad? I have run a forum that used vbulletin with about a 
> 500mb database, but that did not have any issues at all.... but 
> 20-30gb is quite the large database :p
>
> Any thoughts or experiences?
>
> -- 
> Keith Richardson
>
This may not be anything close to what you want to do, but have you seen 
ZoneMinder?
http://www.zoneminder.com/

-=john andrews http://www.seo-fun.com






More information about the talk mailing list