I have created a ASP-based web page that queries an access database for chemical sampling data, and then uses a PHP-script to generate charts from each of the existing chemical compounds in the query. Like this:
1. ASP code with query to filter out chemical data for station x from all years
2. For each compound in the query, call a PHP-script generating a chart using
3. End ASP-script
Both scripts run fast and smooth, but sometimes (the first time the page is called) some of the charts are not downloaded correctly, or at least show up as red crosses. If the page is refreshed all charts show up.
Can someone explain to me where the problem is? Is the PHP too slow, or the ASP too fast, or too many compounds asked for at once. You can check the page out at http://www.lagansvattenrad.se/htm/utdata.asp. Any advice as to where the bottleneck is would be much appreciated.