NYCPHP Meetup

NYPHP.org

[nycphp-talk] LARGE mysql database performance

Jonathan Hendler hendler at simmons.edu
Tue Jan 31 17:53:42 EST 2006


As a follow up:

If you want users not to directly access images you can handle this 
through mod_rewrite in apache and/or just pipe all images through a php 
buffer....
But that's a bit slow.


Keith Richardson 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
>
>------------------------------------------------------------------------
>
>_______________________________________________
>New York PHP Community Talk Mailing List
>http://lists.nyphp.org/mailman/listinfo/talk
>New York PHP Conference and Expo 2006
>http://www.nyphpcon.com
>Show Your Participation in New York PHP
>http://www.nyphp.org/show_participation.php
>  
>




More information about the talk mailing list