load handling

[meet_raman]

i currently use an image hosting script which doesnt seem capable of handling a large number of requests..

here is the problem i am having..

my image hosting site is quite popular and recieves more than 300000 hits a day.. my current script accesses the DB each time an image is displayed in order to keep record of the bandwidth of the image being displayed..

my host says this is leaving far too many open SQL connections and its obviously not desired...

how does AIHS handle this kind of load.. ??

[yabsoft]

Now AIHS query DB each time when showing a image too.But it seem it worked fine.Some big site can load smoothly,This topic (http://yabsoft.com/forum/viewtopic.php?t=110) will be helpfull for you.
(If you encouter "many connections",you can try to use instant connection by "mysql_connect",not "mysql_pconnect" ).

Also,AIHS support mutiple server,which may distribute server resources rationally.

We have planed to use "cache" function or "apache logs" to track the bandwidth and views in future version.This will save lots of db connections,but the track of bandwidth and views is not instant.

[meet_raman]

that version shud be worth the wait :)

i am almost final with your script.. shall clear out some of my doubts with you personally ..

regards