Script Time Out Error with MySql Database

[printas]

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?

[printas]

I just need to Index my search fields in the database, and removed those fields that are not use for searching!