[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