Hi,
I'm not sure if this is a Perl, Apache, MySQL, DBManSQL or Internet Explorer problem so I'm going to post it here and see what happens.
I have a perl script (DBManSQL) that does the following -
1/ Searches a MySQL database based on html form input.
2/ Based on the above search it then performs about 4 additional queries on different MySQL tables for each of the results in 1/ above and additional data is gathered (using a seperate plugin).
3/ All of the data (original result plus additional data) is combined and the final html code is generated by looping through the hits.
4/ The final html code is returned to the browser.
If there are only one or two hits in the original search, the final result is displayed in my browser as it should be. The problem is when there are more results, my browser just gives up (blank page) after a few seconds or I get the "page can't be displayed" message.
It seems to depend on the amount and type of html code being returned. For example, if there are too many links or table rows it causes the problem. If I comment out some of the perl code so it doesn't generate so much code it seem to work.
I'm running everything locally so it's not my internet connection or web hosting service.
Does anyone have any ideas what might be causing or contributing to this problem? Why doesn't my browser wait for everything to come through?
My specs are as follows -
Pentium 4 - 2.26GHZ with 1GB RAM
Win XP / Apache 2 / ActivePerl-5.8 / mysql-4
Internet Explorer 6
Thank you.
I'm not sure if this is a Perl, Apache, MySQL, DBManSQL or Internet Explorer problem so I'm going to post it here and see what happens.
I have a perl script (DBManSQL) that does the following -
1/ Searches a MySQL database based on html form input.
2/ Based on the above search it then performs about 4 additional queries on different MySQL tables for each of the results in 1/ above and additional data is gathered (using a seperate plugin).
3/ All of the data (original result plus additional data) is combined and the final html code is generated by looping through the hits.
4/ The final html code is returned to the browser.
If there are only one or two hits in the original search, the final result is displayed in my browser as it should be. The problem is when there are more results, my browser just gives up (blank page) after a few seconds or I get the "page can't be displayed" message.
It seems to depend on the amount and type of html code being returned. For example, if there are too many links or table rows it causes the problem. If I comment out some of the perl code so it doesn't generate so much code it seem to work.
I'm running everything locally so it's not my internet connection or web hosting service.
Does anyone have any ideas what might be causing or contributing to this problem? Why doesn't my browser wait for everything to come through?
My specs are as follows -
Pentium 4 - 2.26GHZ with 1GB RAM
Win XP / Apache 2 / ActivePerl-5.8 / mysql-4
Internet Explorer 6
Thank you.