Script Time Out Error with MySql Database
I am getting ASP error 0113 Timed Out with my shopping cart asp script with mysql database backend hosted in Window Server webhosting company.
I can't figure out whether is my webhosting provider server that is not configured correctly or is it something wrong with the shopping cart script I am using.
The problem: whenever I do a search for an item, the script would produce an ASP ScriptTimed Out error 0113. I have to to add in a line of code ScriptTimed Out=240 into the asp page in order to avoid timing out. It works, But then this would cause the search to take more than 5 minutes! just to produce some result.
I am using MySQL as the database with 1700 products item in it, and hosting in Windows 2K server. Now, could it because the webserver I am hosting is not configure properly or is it because MySql database is just not very good to be use in Windows Server environment?
Any suggestions?
|