Re: Digital Downloads and Scale

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



dg wrote:
Hello everyone,

I'd appreciate any insights, or source suggestions regarding site traffic and necessary adjustments.

For example, I'm using a simple digital download page for an indie artist. Not a ton of traffic, not a ton of concurrent requests.

Was thinking about introducing something similar for a bigger artist(though still not huge) and I'm concerned for any trouble more demand might create. On the web server side, I'm not worried, as it's on a Pair high volume account.

I am concerned where I might need back-ups or adjustments to code and database queries. Not quite sure where to start in researching this - any ideas or keywords would be appreciated.

Backups are just space, so make sure you have enough to meet your demands. Most hosts will add an extra 10G or something for a flat rate per month so as you need more, you can buy more backup space.

Database queries are harder. Fill up your database with random data and see which bits go slow. If you're using mysql, enable slow-query-logs and see what shows up. If you're using something else, see the appropriate documentation to see if they have an equivalent.

Make sure you use random data because if you use the same data for each record, the database won't be able to utilize indexes properly.

--
Postgresql & php tutorials
http://www.designmagick.com/

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux