Jeg lavede engang en lille test med ASP.NET + MySQL + 1000 billeder af 25 KB (ikke helt dit setup, men jeg tror at resultaterne kan overfoeres):
File (1 threads): 1,9 get per second File (10 threads): 2,2 get per second File with web app cache (1 threads): 6,6 get per second File with web app cache (10 threads): 16,1 get per second File directly by web server (1 threads): 17,6 get per second File directly by web server (10 threads): 20,1 get per second Database (1 threads): 10,7 get per second Database (10 threads): 11,8 get per second Database with web app cache (1 threads): 15,4 get per second Database with web app cache (10 threads): 19,6 get per second File (1 threads): 1,9 get per second File (10 threads): 2,2 get per second File with web app cache (1 threads): 16,7 get per second File with web app cache (10 threads): 19,4 get per second File directly by web server (1 threads): 17,1 get per second File directly by web server (10 threads): 20 get per second Database (1 threads): 10,7 get per second Database (10 threads): 11,9 get per second Database with web app cache (1 threads): 17,3 get per second Database with web app cache (10 threads): 19,6 get per second File (1 threads): 1,9 get per second File (10 threads): 2,1 get per second File with web app cache (1 threads): 16,8 get per second File with web app cache (10 threads): 17,8 get per second File directly by web server (1 threads): 17,6 get per second File directly by web server (10 threads): 20,1 get per second Database (1 threads): 10,7 get per second Database (10 threads): 11,6 get per second Database with web app cache (1 threads): 17,1 get per second Database with web app cache (10 threads): 19,5 get per second
ja, det "ER" at være en dum idé at gemme i DB, hvis der er mange...
ps. det kører på w2k3, og sql 2k5...
PS: 1% ER en "drøm", fra dem jeg laver det for.. Jeg har tidligere lavet det samme filbaseret (hver 10000 fik sin egen mappe (1-10000,10001-20000 osv), men så skal/er der jo meget fil access for at checke om billedet er der (kunne jo også registreres i db'en men så er der 4 ekstra felter)
Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.