NYCPHP Meetup

NYPHP.org

[nycphp-talk] LARGE mysql database performance

Sean Pangia spangia at redcent.net
Tue Jan 31 16:07:20 EST 2006


is non-direct linking the only advantage to be gained? if so, why not
just use PHP to do a file read from an htaccess protected directory
where the actual images live? same result -- people have to go through
the app.


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

-- 

   _______________________________________
   Sean Pangia

   Red Cent
   54 West 21st Street, #607
   NYC 10010

   212.255.3800
   www.redcent.net





More information about the talk mailing list