NYCPHP Meetup

NYPHP.org

[nycphp-talk] LARGE mysql database performance

Warren Myers volcimaster at gmail.com
Tue Jan 31 16:09:33 EST 2006


Well, slashdot runs on MySQL, and they don't have too many problems with
handling large quantities of both data and users.

WMM

On 1/31/06, Keith Richardson <keith at keithjr.net> 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
>
>
>


--
http://warrenmyers.com
"God may not play dice with the universe, but something strange is going on
with the prime numbers." --Paul Erdős
"It's not possible. We are the type of people who have everything in our
favor going against us." --Ben Jarhvi, Short Circuit 2
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.nyphp.org/pipermail/talk/attachments/20060131/fba3d4c6/attachment.html>


More information about the talk mailing list