we are developing a VB.net 2.0 job portal. Sql 2005 is at the rear. It has some related DD lists and we have emplted Ajax for filling up the child controls. The cacading DDL were avoided as our server(maximumasp) is havving some issue with web services.
The DDL is bound to corresponding datatable objects. each of these dt is populated from a cache object. First the data is loaded to cache at page load and then further data retrieval is from this cache.
the trouble now is that these DDLs are running extremely slow at the production server. the same code is performing very well at the development server, even when the database used is remote.
I tried with uncompiled and compiled code locally and remotely in three different servers ! the results are always same -
any idea what is happening?
Help me !